Recent content by TracyV

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...

I have a flat file i want to update via SQL. I am not very proficient in SQL so I'm not sure how to do this. I have three 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...

First of all, we have NO embedded sql on any of our systems for me to refer to. I am experimenting and my program is probably full of don'ts. I'd appreciate anyone's suggestion/explaination as to why this is taking as long as 5-8 minutes to process 31 files. (Maybe that is normal? I don't...

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

Could anyone tell me how to change the SQL below to populate by relative record number or the arrival sequence in ASCOMM? The file does not have a sequence number in which to sort the order the comments were added, so arrival sequence would work for what I need. Thanks...

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.

The system I am working on does not have SQL. the logical COHSTTL5 is the ONLY object on their system by that name, so I know the query and program are using the same file. Below is the logical. Nothing unusual about it. 5722SS1 V5R2M0 020719 Data Description...

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?