× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. October 2011

RE: Dumb SQL question

As someone earlier mentioned, looks like primary keys.

Take a look at this and look for articles by Kent Milligan for more info.

http://www.centerfieldtechnology.com/publications/archive/Feb-Mar09.pdf


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Paul Nelson
Sent: Wednesday, October 26, 2011 11:23 AM
To: 'Midrange Systems Technical Discussion'
Subject: RE: Dumb SQL question

Using SQL, and prompting for the fields:

Seq Field File Text
HRTEMPID HRTEMP HRTEMP Record Id
STATUSCODE HRTEMP Status Code
SRCCNCID HRTEMP Src SYTCNC Id
COMPANYNUMBER HRTEMP Src Com
DIVISIONNUMBER HRTEMP Srd Div
EMPCNCID HRTEMP Emp SYTCNC Id
EMPLOYEECOMPANY HRTEMP Emp Com
EMPLOYEEDIVISIO > HRTEMP Emp Div
CHGCNCID HRTEMP Chg SYTCNC Id
CHGCOMPANYNO HRTEMP Chg Com
CHGDIVISIONNO HRTEMP Chg Div
SOCIALSECNO HRTEMP Soc/EI No
PRTMSTID HRTEMP PRTMST Rec Id
EMPLOYEENUMBER HRTEMP Empl No

This is the HR module employee master. PRTMST is the employee master in the
actual payroll system. This also has the old DDS field names when I toggle.

Paul Nelson
Office 512-392-2577
Cell 708-670-6978
nelsonp@xxxxxxxxxxxxx


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Wednesday, October 26, 2011 12:03 PM
To: Midrange Systems Technical Discussion
Subject: Re: Dumb SQL question

I would need to see a sample. I have some guesses as to what's going on
but I'm withholding them until I see examples.


Rob Berendt

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.