Cataloging Stored Procedures
Need to know if anyone has a package or process to do the actual storing of information around a Stored Procedure? My area is being tasked with becoming the Librian for all of our stored procedures whether created with true Sequel or RGP with imbedded SQL. I am looking for a way out side of say...
Need to know if anyone has a package or process to do the actual storing of information around a Stored Procedure? My area is being tasked with becoming the Librian for all of our stored procedures whether created with true Sequel or RGP with imbedded SQL. I am looking for a way out side of say...
0 pts.
Debugging Group Jobs
Is there anybody to help me in getting the procedure for debugging a group job. Thank you for any help in advance. regards, Deepa
Is there anybody to help me in getting the procedure for debugging a group job. Thank you for any help in advance. regards, Deepa
can strqmqry be run as remote command
I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...
I am trying to run strqmqry via a dos/cmd ftp session. command: QUOTE RCMD STRQMQRY QMQRY(lib/qry) ... where ... are other options I followed various instructions posted here and on as400 tech sites on how to create the query. I was able to do all of that via a dos/cmd ftp session (except for...
CPYTOIMPF Nightmare
I am using this to transfer data from the S400 to the IFS. The data has to be tab delimited. I am the sending the data to a UNIX box. the problem is I am a getting a carriage return at the end of fields - and it appears to be random. Here is my command CPYTOIMPF FROMFILE(*LIBL/IOBEXT) + ...
I am using this to transfer data from the S400 to the IFS. The data has to be tab delimited. I am the sending the data to a UNIX box. the problem is I am a getting a carriage return at the end of fields - and it appears to be random. Here is my command CPYTOIMPF FROMFILE(*LIBL/IOBEXT) + ...
MS SQL Server 2000
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?
OPNQRYF's MAPFLD
I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined...
I am trying to create an OPNQRYF and use MAPFLD. I need to place conitionally one of two fields into ALPHANAME, I defined in MAPFLD. These fields are conditionally placed as follows: LNAME ===> ALPHANAME if LNAME is filled. BUS_NAME==> ALPHANAME if LNAME is blank APHANAME is defined...
SYNON vs COBOL
Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...
Hi All, This query is related to performance. I am currently in the process of changing an application from COBOL to Synon. The application uses a lot of I/O involving files. Upon converting the application to Synon, I find that the performance has declined - COBOL takes 8 minutes whereas Synon is...
Display Footers in Subfiles
Hi, I have a dual display subfile. I am able to do display the screens allright but it's the footer record i am unable to display at all. I have made sure that the second subfile record doesn't overlap my footer area (by footer, i mean the area where i want to display my Function keys). I have...
Hi, I have a dual display subfile. I am able to do display the screens allright but it's the footer record i am unable to display at all. I have made sure that the second subfile record doesn't overlap my footer area (by footer, i mean the area where i want to display my Function keys). I have...
Using S/36 object members (load and subroutine) on AS/400
Hello, We are looking for IBM-supplied commands that will convert and/or run S/36 object members (load and subroutine members) to useable AS/400 system objects. The fact is that we lost the RPG source code from the S/36; so there is no source to compile on the AS/400. We look forward to your help. ...
Hello, We are looking for IBM-supplied commands that will convert and/or run S/36 object members (load and subroutine members) to useable AS/400 system objects. The fact is that we lost the RPG source code from the S/36; so there is no source to compile on the AS/400. We look forward to your help. ...
MONMSG and SNDRPY
Dear, I'm trying to write a small program to run my backup job via BRMS... and I would like to check the different errors and reply automatically to few of them. Ok, I can monitor the error messages through MONMSG but how can I reply to them ? I know that I have to use SNDRPY but how can I have the...
Dear, I'm trying to write a small program to run my backup job via BRMS... and I would like to check the different errors and reply automatically to few of them. Ok, I can monitor the error messages through MONMSG but how can I reply to them ? I know that I have to use SNDRPY but how can I have the...
FTP from Client site
I am trying to receive data from a client site into an externally described file on my ISerie. Data will be received daily and the file name is date stamped, (for example:filea103106, filea110106)my problem is that since it needs to be copied into MYLIB/MYFILE, I cannot use the MGET filea* to copy...
I am trying to receive data from a client site into an externally described file on my ISerie. Data will be received daily and the file name is date stamped, (for example:filea103106, filea110106)my problem is that since it needs to be copied into MYLIB/MYFILE, I cannot use the MGET filea* to copy...
create computations on the fly
We are primarily a COBOL shop. We have some COBOL ILE and some RPG. I have a need to replicate a function on the I-series that is currently done in Excel. This function allows them to create formulas on the fly to arrive at pricing information. I can work through issues with interactive...
We are primarily a COBOL shop. We have some COBOL ILE and some RPG. I have a need to replicate a function on the I-series that is currently done in Excel. This function allows them to create formulas on the fly to arrive at pricing information. I can work through issues with interactive...
Transition from RPG fixed-format to Free-Format
We are an iSeries installation (V5R3) with a team of 6 developers. Our background is good old-fashioned RPG but 2 of our team members have started coding in free-format, having bought a book but with no formal training undertaken. It is a given that the future is in free-format, but, going...
We are an iSeries installation (V5R3) with a team of 6 developers. Our background is good old-fashioned RPG but 2 of our team members have started coding in free-format, having bought a book but with no formal training undertaken. It is a given that the future is in free-format, but, going...
MACPAC from V5R2 to V5R3
We are looking to upgrade from V5R2 to V5R3 and we are a macpac SHOP. I understand that there are some required PTF's from MACPAC support that are required to go to V5R3. Has anyone gone to V5R3 with out these so called PTF's? Anyone have any idea what these PTF's are? What could MACPAC code...
We are looking to upgrade from V5R2 to V5R3 and we are a macpac SHOP. I understand that there are some required PTF's from MACPAC support that are required to go to V5R3. Has anyone gone to V5R3 with out these so called PTF's? Anyone have any idea what these PTF's are? What could MACPAC code...
Increase Size of Network Storage Area
I have a client that needs to increase the size of the NWS being used with Windows Server 2003. It is a mapped drive for all users. Can anyone help with the steps required to change the size and maintain the drive mapping? They are on V5R3. Any suggestions will be appreciated.
I have a client that needs to increase the size of the NWS being used with Windows Server 2003. It is a mapped drive for all users. Can anyone help with the steps required to change the size and maintain the drive mapping? They are on V5R3. Any suggestions will be appreciated.
Looking for a Jacada User Group
I am trying to determine if anyone has created a Jacada User Group or would be interested in starting a Jacada User Group. My company currently uses the JIS product.
I am trying to determine if anyone has created a Jacada User Group or would be interested in starting a Jacada User Group. My company currently uses the JIS product.
Optical storage
I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to...
I am trying to copy database files from the iSeries to a DVD (optical storage) and would like the files on the DVD created in ASCII text format. Similar to a data transfer from the iSeries, you can specify the file type ASCII text. The database files are actually spooled files that were copied to...
Tools for DDS to DDL migration
Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...
Hi, My Profile: I have a legacy DDS defined DB2/400 database and my IT staff are telling me that for true SQL/ODBC access we either need to migrate the database over to DDL defined tables or add unique indexes to the existing DDS structure. My Question: Do we really need to alter the DDS database...
QDLS and the IFS
How can I access the QDLS library in a CLLE program? I am using the copy database to an optical file command and CLLE program (CPYDBOPT). I created a folder called "Optical". I can see this folder using iSeries Navigator. I don't see a QDLS library on my iSeries when use I use the work with...
How can I access the QDLS library in a CLLE program? I am using the copy database to an optical file command and CLLE program (CPYDBOPT). I created a folder called "Optical". I can see this folder using iSeries Navigator. I don't see a QDLS library on my iSeries when use I use the work with...
