I have a program stuck in a loop that is using a logical. I'm wondering how I can find the record within the physical. I assume the I/O record and relative record number are referring to the logical and not the physical. Is there anyway to display a relative record number in a logical...
I am new to SQL and am having difficulties inserting data into my file.
I have two files. Both the priority_address and the mailing_address files have the exact same layout:
PRIORITY
ACCOUNT
TENANT
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
CITY
STATE
POSTAL
The Priority_Address file may have up to...
I have a make table query in Access 2007 that has a city field that is in all caps. I want to convert the city to lower case, but I want the first letter of each word in the city to be capitolized. Is this possible in the expression builder? If I use LowerCity: LCase([B5CZTX]), all words in...
I have a packed field that is 4.0 long but when you look at it in hex the first and last positions are not valid. I have a field that looks like:
217
60C
the 6107 is valid, the 2 should be 0 and the C should be F.
Is there a way to write an RPG program to fix this problem? I have not written...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.