Dear All, I am learning to write CL program in AS/400 for DB2, maybe call new programmer. I have a file1 include ( field 1 ->10) to have value as: Field 1 Field 2 Field 3 Field 4 Field 5 Field 6 Field 7 Field 8 Field 9 112118 P I 1 A B C D E I want to create CL program update file 1 in AS/400 to...
Thanks! We'll email you when relevant content is added and updated.
What is the actual usage of %Check and %Checkr opcode? As far my understanding it should check for non occurrence of the given sting. Consider below case: DName S 10A INZ('VIVEKAM') DPos S 5 0 INZ(0) ...
Thanks! We'll email you when relevant content is added and updated.
I am using an SQL statement to insert into a file. I am doing some sub-stringing on a record then inserting into another file. I am getting a LVLCHK error on the output file. How can I use OVRDBF in my CL to insert to my output file? My file PROFILE has the data and PROFILE2 is my output file and...
Thanks! We'll email you when relevant content is added and updated.
I would like to create a control group where a set of 10 libraries will be saved on a tape which BRMS picks randomly. And the second set of 10 libraries needs to be saved in another random tape. Intention is not to save all 20 lib together, How to accomplish this. Could you please help?
Thanks! We'll email you when relevant content is added and updated.
Hi, I have a file with some duplicate records and I want to filter them using wrkqry can anyone please advise how to remove duplicate records using this? I am comparing three fields lets say F1,F2,F3 and comparing them with each other for similar records and for field 4 lets say it's f4 i want to...
Thanks! We'll email you when relevant content is added and updated.
Pf 1 file contain records below: Roll No Subject Marks 1 S1 100 2 S2 80 1 S1 60 2 S2 70 Another file PF2 Contain records below, Roll No Marks 1 180 2 ...
Thanks! We'll email you when relevant content is added and updated.
I have a situation in my project, we have to retrieve values in array using pointer. I was able to get the pointer value in my Called program with the array being in working-storage section, In my calling program, I'm able to retrieve the pointer value and have defined the array in LINKAGE section...
Thanks! We'll email you when relevant content is added and updated.
As CRTJVAPGM is no longer supported (with V7R2), how should we create a Java program? I have some Java programs written in eclipse tool. My RPGLE procedures invoke the java programs. I want to debug the Java program, and hence like to create Java program in iSeries. Is that possible?
Thanks! We'll email you when relevant content is added and updated.
I have to set a control group which performs the below: I have a set of 10 lib to be backed up by BRMS in a volume. But next set of 10 tapes should be backed up in another random volume in BRMS. How do I achieve this?
Thanks! We'll email you when relevant content is added and updated.
Problem: I am trying to access a data area on a library that is in an iASP partition via a java program. I am using jt400 to create a jdbc connection to access the said data area. then getcharacterdataarea.class to basically access the data area, with the filepath paramater pointed to the iASP...
Thanks! We'll email you when relevant content is added and updated.
Hi, I'm using FTP scripts to transfer PDF files from AS/400 system to Remote System. I'm creating a new directory in remote system using MKDIR command and then doing the data transfer as below. LCD /LOCAL/PDF MKDIR /REMOTE/PDF1 CD /REMOTE/PDF1 PUT FILE1.PDF FILE1.PDF But the Remote System...
Thanks! We'll email you when relevant content is added and updated.
I have an IBM i table in *SYSBAS. I'm trying to open with commitment control from a job / program that is running under an iASP. The object library of the program is also on the iASP. I get the error message CPF432A RC9. RC9 says internal system failure. Is this something that you guys have...
Thanks! We'll email you when relevant content is added and updated.
What is difference between Return vs *inlr in RPGLE? I have below scenario: PGM 1 PGM2 SOME LINES some lines CALL pgm2 Return some lines *INLR = *ON What will happen in the above scenario?
Thanks! We'll email you when relevant content is added and updated.