Search results for query: *

I have two PCs on my desk. Both run the same version of client access. When I do a print screen from one PC, it prints fine. When I do a print screen from the other, the font is larger and the CPI is smaller causing the print screen to be very hard to read. I've compared both PCs side by...

I'm still missing the CSB6REP file which is where I get the landlord number to get to the account (CSI8REP) file. UPDATE tlvlib/eplp14 A SET ( A.tharea1, A.thphon1 ) = (( SELECT coalesce i8zjn1, i8zjn1 FROM csi8rep WHERE i8kgnb = A.q0kgnb...

I don't see where the CSB6REP - Landlord File is accessed. The statement should only be performed if the landlord number on the CSB6REP is not equal to zero. Then using that landlord number, link to the phone number file to get the phone numbers. From there, link to the flat file and update...

...files I need to access in this statement: EPLP14 - Flat File CSB6REP - Landlord File CSIOREP - Phone Number File If the landlord (B6KINB) NE *Zeros (CSB6REP file) link to the flat file i want to update (EPLP14 file) with the landlord field (CSB6REP/B6KINB) to the landlord field on the...

...next year, bla bla, but it's just another delete/insert action. Below is my sql for one of the 31 files. (the rest are essentially the same) C*=========================== C* ASUTIL C*===========================...

C/Exec SQL C+ Insert into QTEMP/ASCOMM C+ Select * from MDNASDEV/ASCOMM C+ Where CCEN = :Century and C+ CYR = :Year and C+...

...C/Exec SQL C+ Insert into QTEMP/ASCOMM C+ Select * from MDNASDEV/ASCOMM C+ Where CCEN = :Century and C+ CYR = :Year and C+...

I'm having problems calling modules, it looks like i need to use Extproc instead of Extpgm. Extproc is not allowing me to use a variable for the program name. I'd have to setup a different prototype for each call? What i am doing is reading a file which contains a selection and a program...

Thank you for your posting, it was quite helpful! I have a question regarding the code you supplied. If I understand correctly, this code does a 'CALL' to the desired program. Is it possible to do a 'CALLB' rather than a 'CALL'?

Could use an SQL statement to delete all the records where CO# = 'H' C/Exec SQL C+ Delete from QTEMP/BILLOUT C+ Where CO# = 'H' C/End-Exec

Is it possible to use a variable when using CALLB? Depending on the selection, i want to CALLB different programs. Not sure if this is a subprocedure thing, not realy familiar with those yet. Any suggestions would be greatly appreciated!!

I put a break directly after the read statement. I've done a step thru numerous times. Only three records are read. What's strange is it's every other record of the five records! I'll follow thru with your SQL suggestion and move the file to our system and try that.

...Source member last changed . . . . . . . . . . . . : 06/16/05 14:45:16 Source listing options . . . . . . . . . . . . . . : *SOURCE *LIST DDS generation severity level . . . . . . . . . . . : 20 DDS flagging severity level . . . . . . . . . . . . ...

I checked the file description. There are no deleted records in the file. I ran both the query and the program over the same logical. I've checked to make sure there are no other files with the same name. I know it reads three records, because I put the program into debug and only three...

No, they are not deleted records. If they were, would they even show up in the query?

In a query I can display five records equal to the key I am using within my program, but when I reade within my program, I am only accessing three records. It's like it's reading every other record. Any ideas??

Artiztik- '*' automatically loads the program name for you. I did figure out the problem.....well sort of. I removed the command keys on the bottom of the screen and ran the program...error messages displayed fine. Put the command keys back on the screen....message subfile did not display...

...are never moved to the message subfile. I Any suggestions would be greatly appreciated!!! A DSPSIZ(24 80 *DS3) A PRINT A R SCRN01 A...

Works great now!!!!!! Thanks!!!!!!!

I thought it would be the edit code as well, but it's not the case. I've tried all the edit codes, including the IBM supplied user defined edit codes 5-9. Like I said, the field displays correctly if its an OUTPUT field, its when it's both INPUT and OUTPUT (B) and the user uses the field minus...