ovrdbf doesn't get deleted with a dltovr
I've got a cl that copies a PF file to qtemp then I use CRTDUPOBJ to get a LF attached to the qtemp PF file. Then ovrdbf of LF to qtemp/LF with OVRSCOPE(*JOB). After calling 2 programs to update the qtemp/LF I DLTOVR FILE(*ALL) LVL(*JOB). But the override stays doesn't get deleted. I can't figure...
I've got a cl that copies a PF file to qtemp then I use CRTDUPOBJ to get a LF attached to the qtemp PF file. Then ovrdbf of LF to qtemp/LF with OVRSCOPE(*JOB). After calling 2 programs to update the qtemp/LF I DLTOVR FILE(*ALL) LVL(*JOB). But the override stays doesn't get deleted. I can't figure...
45 pts.
Maximum number of CL variables with IBM i 6.1
What is the maximum number of variables that you may define using the DCL command in a CL program on an IBM i version 6.1 system? Also: Where is this documented, if you know? I couldn't find it in the online help, Information Center, or CL Programming PDF. Thanks!
What is the maximum number of variables that you may define using the DCL command in a CL program on an IBM i version 6.1 system? Also: Where is this documented, if you know? I couldn't find it in the online help, Information Center, or CL Programming PDF. Thanks!
CL problem with purge
The below code was written to automatically purge files once in 2 months.The problem here is that there are months with 30,31 and 28 days so while deletion some files may be left out.Can this be rectified. CHGVAR VAR(&PYD) VALUE(&PYC) CHGVAR VAR(&PMD) VALUE(&PMC) CHGVAR ...
The below code was written to automatically purge files once in 2 months.The problem here is that there are months with 30,31 and 28 days so while deletion some files may be left out.Can this be rectified. CHGVAR VAR(&PYD) VALUE(&PYC) CHGVAR VAR(&PMD) VALUE(&PMC) CHGVAR ...
CL Program
Hello, I have these queries on a job schedule now and, I want to export them to excel using CL.. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two file to? and can I run both queries this way? thanks,
Hello, I have these queries on a job schedule now and, I want to export them to excel using CL.. PGM RUNQRY MYENTRIES1 RUNQRY MYENTRIES2 COPYTOIMPF FROMFILE(MYLIB/MYFILE1) (MYLIB/FILE2) ENDPGM Where do I send these two file to? and can I run both queries this way? thanks,
cl
DCL &TEXTFILENM *CHAR 40 dcl &curdt *char 6 dcl &curtm *char 6 /* build your CL file name as */ RTVSYSVAL SYSVAL(QDATE) RTNVAR(&CURDT) RTVSYSVAL SYSVAL(QTime) RTNVAR(&CURTM) ChgVar &TextFileNm (QDATE *TCAT QTIME *TCAT ‘.TXT’ CPYTOIMPF … To stream file . . . . . . . . . TOSTMF &TextFileNm ...
DCL &TEXTFILENM *CHAR 40 dcl &curdt *char 6 dcl &curtm *char 6 /* build your CL file name as */ RTVSYSVAL SYSVAL(QDATE) RTNVAR(&CURDT) RTVSYSVAL SYSVAL(QTime) RTNVAR(&CURTM) ChgVar &TextFileNm (QDATE *TCAT QTIME *TCAT ‘.TXT’ CPYTOIMPF … To stream file . . . . . . . . . TOSTMF &TextFileNm ...
cl
i have a flat file. data is populated to this file on a daily basis. I need to create a new member every day as and when the flat file is populated.In my cl code I tried using AA *cat &qdate in addpfm and build the name of the file but couldnt do so...As stated earlier i neeed this to purge members...
i have a flat file. data is populated to this file on a daily basis. I need to create a new member every day as and when the flat file is populated.In my cl code I tried using AA *cat &qdate in addpfm and build the name of the file but couldnt do so...As stated earlier i neeed this to purge members...
cl
Hi 1.I need a cl code that will purge text files that are more than 3 months old...text files will be created with the date of creation suffixed to the filename... 2.If the above is not possible will i be able to create flat file members and purge those file members.
Hi 1.I need a cl code that will purge text files that are more than 3 months old...text files will be created with the date of creation suffixed to the filename... 2.If the above is not possible will i be able to create flat file members and purge those file members.
Need a CL to be written
Hi I need a cl to be written;The requirement is as follows There will be files created with naming convention INV20081219 or members within files. Now i need a program that will automatically delete files that are more than 3 months old.
Hi I need a cl to be written;The requirement is as follows There will be files created with naming convention INV20081219 or members within files. Now i need a program that will automatically delete files that are more than 3 months old.
CL SysDate Conversion
Hi I have converted the sys date to *CYMD format.I have two problems, 1.For eg 19/12/08 is now 1081219,where 1 stands for 2000-2050 and 0 stands for 1900 to 1999(defined in system).But i want to map this with dates in file whose format is 20081219. 2.If this is possible i need to subtract the...
Hi I have converted the sys date to *CYMD format.I have two problems, 1.For eg 19/12/08 is now 1081219,where 1 stands for 2000-2050 and 0 stands for 1900 to 1999(defined in system).But i want to map this with dates in file whose format is 20081219. 2.If this is possible i need to subtract the...
Java User Profile Usage
On the I-series, I hava a java application being run within a CL program using the RUNJVA command. How can I get the java app to use a different user profile/job description than the CL program itself.
On the I-series, I hava a java application being run within a CL program using the RUNJVA command. How can I get the java app to use a different user profile/job description than the CL program itself.
protect_lines backarrow drags protected text down into editable area
I have used CL_GUI_TEXTEDIT class to create a custom control for text entry. I am using the PROTECT_LINES method to afix a date/time stamp and then make it non-editable. The problem is, when I am in the editable area and I hit back-arrow until the cursor jumps up to the end of the protected...
I have used CL_GUI_TEXTEDIT class to create a custom control for text entry. I am using the PROTECT_LINES method to afix a date/time stamp and then make it non-editable. The problem is, when I am in the editable area and I hit back-arrow until the cursor jumps up to the end of the protected...
managing authorization list
a long time ago, I retrieved a CL from this site to manage authorization list. It displayed all the list to an output file and the CL uses the input file to properly balance the users and objects authority. Does anyone have something similar?
a long time ago, I retrieved a CL from this site to manage authorization list. It displayed all the list to an output file and the CL uses the input file to properly balance the users and objects authority. Does anyone have something similar?
Highlighting or sending colored text from CL to QSYOPR
Is it possible to send a break message or User Message from a CL Program to QSYSOPR message queue with highlighted text or in different color? The purpose of this is to catch the operators attention to this message from other normal messages.
Is it possible to send a break message or User Message from a CL Program to QSYSOPR message queue with highlighted text or in different color? The purpose of this is to catch the operators attention to this message from other normal messages.
strpccmd
CL program uses this command to download file from AS/400 machine on to the PC using TTO.But download is not happening properly.can someone help?
CL program uses this command to download file from AS/400 machine on to the PC using TTO.But download is not happening properly.can someone help?
To use Arithmetic operations in Cl program
Hi, i am fresher for AS400.I dont know how to retreive a sysval using arithmetic operations in cl programming and too storing in a dataarea and displaying the result through msg
Hi, i am fresher for AS400.I dont know how to retreive a sysval using arithmetic operations in cl programming and too storing in a dataarea and displaying the result through msg
Reading IFS file from CL program
I have a requirement of reading a IFS file from CL program. As far as I know there is no direct way of achieving this. I am planning ot use CPYFRMSTMF followed by CPYF to copy the IFS file first as a memeber and then as a database file. Is there any better way to achieve this? Regards Sudip
I have a requirement of reading a IFS file from CL program. As far as I know there is no direct way of achieving this. I am planning ot use CPYFRMSTMF followed by CPYF to copy the IFS file first as a memeber and then as a database file. Is there any better way to achieve this? Regards Sudip
