triggers
i know you can attach a trigger to a physical file, but can you attach one to a print file or even a display file. thanks in advance
i know you can attach a trigger to a physical file, but can you attach one to a print file or even a display file. thanks in advance
0 pts.
Synon/Cool:2E - internal/external func performance question
I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...
I have a situation where I have to call a synon function multiple times (for each record in a file one after another) from another synon function. The called function does some calculatons. Will there be any performance improvement if I make the called func an internal function and have an external...
ftp error codes
Hi! I'm writing a program that needs to execute the FTP command n times (where n is determined by the value of some field in a DDS table), only if there is an error during one of those executions. The question is: how can I determine if the execution failed? Thanks a lot! :) Meli
Hi! I'm writing a program that needs to execute the FTP command n times (where n is determined by the value of some field in a DDS table), only if there is an error during one of those executions. The question is: how can I determine if the execution failed? Thanks a lot! :) Meli
CPYTOPCD
I can successfully copy data from a PF to a PC doc (via CPYTOPCD) and I can successfully e-mail the resultant PC DOC from the AS400 (via SNDDST) However, when I try to e-mail a large PC Doc (2 meg) I receive about 20 e-mails with *.DTF attachments, which are virtually unreadable. Any ideas?
I can successfully copy data from a PF to a PC doc (via CPYTOPCD) and I can successfully e-mail the resultant PC DOC from the AS400 (via SNDDST) However, when I try to e-mail a large PC Doc (2 meg) I receive about 20 e-mails with *.DTF attachments, which are virtually unreadable. Any ideas?
Printing AS/400 ouptputs in diffrent printers,results in different outcome.
Our server is model 810 running on V5R2. We have a cheque printing program which outputs a spool which is used to print cheques.When the spool file is sent to a LEXMARK 2380/81 2390/91 series printers for print, the data is positioned perfectly in to the cheques. But we have some users who wants to...
Our server is model 810 running on V5R2. We have a cheque printing program which outputs a spool which is used to print cheques.When the spool file is sent to a LEXMARK 2380/81 2390/91 series printers for print, the data is positioned perfectly in to the cheques. But we have some users who wants to...
OVRDBF in JAVA
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
OVRDBF in Java
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
I am trying to insert records to a member in a PF through JDBC. Tried with QCMDEXC in Java. But the member is not being overridden, inserting records in the First Member-always. What may bethe cause? Can any one suggest the possible solution for this?
To retrieve data from a remote system
Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series...
Hi, I have to retrieve data from a remote system (May be of any operating system) and shall put into AS/400. This process should be automated and there can't be any manual intervention. We can not use FTP commands here. Is there any other way this can be achieved. Can?t go for MQ Series...
Additional options for spool files
I would like to add an option to the Work with Job Spooled Files and Work with All Spooled Files screens that will perform exactly like option 2, except that the default for the DUPLEX parameter is (*YES). TIA for all replies.
I would like to add an option to the Work with Job Spooled Files and Work with All Spooled Files screens that will perform exactly like option 2, except that the default for the DUPLEX parameter is (*YES). TIA for all replies.
how to get the location of the User Options (updated usinf PF18 from PDM)
How can I access the Defaults information from Rexx / CL ? PF18 from PDM. I am looking for the values of Option file/lib/member. thanks Change Defaults ...
How can I access the Defaults information from Rexx / CL ? PF18 from PDM. I am looking for the values of Option file/lib/member. thanks Change Defaults ...
ANNOUNCEMENT ? MORE NEW CATEGORIES ADDED TO THE ISERIES CATEGORY
UPDATE YOUR AREAS OF EXPERIENCE The following categories have been added to the AS400 ? iSeries section. Application development Systems management PC/Windows connectivity groupware & e-mail Career Opportunities for iSeries These categories were added last week: Backup & recovery Security...
UPDATE YOUR AREAS OF EXPERIENCE The following categories have been added to the AS400 ? iSeries section. Application development Systems management PC/Windows connectivity groupware & e-mail Career Opportunities for iSeries These categories were added last week: Backup & recovery Security...
Source for a the DSPPGMMSG command
Dan wrote in with this question recently: "I'm trying to find the source for a command called: DSPPGMMSG. I have version 3.2 RPG & CL. I'm trying to run on a 5.2 box and this command is used extensively throughout the CL's. Any info would be greatly appreciated." Can you help Dan out? -- Debra...
Dan wrote in with this question recently: "I'm trying to find the source for a command called: DSPPGMMSG. I have version 3.2 RPG & CL. I'm trying to run on a 5.2 box and this command is used extensively throughout the CL's. Any info would be greatly appreciated." Can you help Dan out? -- Debra...
Time Stamp Issues
Two questions about time stamp: 1. Is there a way to copy members/files etc so that the new member/file will still have the original time stamp (change date etc.) 2. Is there a way to update the member/file change date/time to a specific date/time (without actually saving it) ? thanks !!
Two questions about time stamp: 1. Is there a way to copy members/files etc so that the new member/file will still have the original time stamp (change date etc.) 2. Is there a way to update the member/file change date/time to a specific date/time (without actually saving it) ? thanks !!
verify data file
Hi everyone! I've a CL program that copies a spool file into a PF file. Is there any way to compare both files, in order to assure they have the same information? Thanx in advance :) Meli
Hi everyone! I've a CL program that copies a spool file into a PF file. Is there any way to compare both files, in order to assure they have the same information? Thanx in advance :) Meli
SNDDST with .csv or .xls attachment
Can someone tell me how to send an attachment with a .csv or .xls? When I try, it sends it as .txt and when you open it up, it's all garbage! Also, how can I add headings to an .xls or .csv when using cpytoimpf. All I'm getting now is just data. Thanks!
Can someone tell me how to send an attachment with a .csv or .xls? When I try, it sends it as .txt and when you open it up, it's all garbage! Also, how can I add headings to an .xls or .csv when using cpytoimpf. All I'm getting now is just data. Thanks!
Anyone ever use the SNDRPY command in CL?
I am using the CHGPF command to change a file. I know it will result in data loss, and I will get a messaage that I must reply "I" to ignore and then it will change the file. The file is used all day long and I would like to have a CL program change it after hours. I found the SNDRPY command...
I am using the CHGPF command to change a file. I know it will result in data loss, and I will get a messaage that I must reply "I" to ignore and then it will change the file. The file is used all day long and I would like to have a CL program change it after hours. I found the SNDRPY command...
Special characters
I've got a situation where the users are entering characters into fields on the screen that I do not want them to enter. In COBOL, I can check these fields for alphabetic and numeric but I am under the impresion that this would not allow certain special characters that I do want to allow. Is...
I've got a situation where the users are entering characters into fields on the screen that I do not want them to enter. In COBOL, I can check these fields for alphabetic and numeric but I am under the impresion that this would not allow certain special characters that I do want to allow. Is...
SET verb in COBOL
Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE 'A', 'B', 'C'. 88 NOT-VALID-VALUES VALUE 'D', 'E', 'F'. If I want to set the value...
Hi The SET verb in COBOL set the value of a particular variable to a specified value. Now say I decalred a variable as 05 WS-SWITCH PIC X(01). 88 VALID-VALUES VALUE 'A', 'B', 'C'. 88 NOT-VALID-VALUES VALUE 'D', 'E', 'F'. If I want to set the value...
write in a PF file
Hi everyone! I have an RPGLE program that creates four physical files (using the QCMDEXC program). These physical files have no DDS. In the same program, I read another physical file (that's a copy of a spool file). If the line (s) read met some specified criteria, it needs to be written to one of...
Hi everyone! I have an RPGLE program that creates four physical files (using the QCMDEXC program). These physical files have no DDS. In the same program, I read another physical file (that's a copy of a spool file). If the line (s) read met some specified criteria, it needs to be written to one of...
How to operating with Multiple Member PF in RPG ?
I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with...
I have a multiple member physical file and I want to operate(read/update/delete) with specific member in RPG. The member name for that PF need to be set at runtime depending upon from which program this rpg program is called. I am writing the sample code that I was trying, but it ends up with...
