Job in MSGW
My Job is in MSGW. I want to know at what time it went in MSGW? For Example- Lets say I submitted a Job at 4 PM and after running for half an hour it went to MSGW at 4:30. So I want to how programatically or by some commad which returns me the time [...]
Answer Question
| March 17, 2012 3:05 PM
AS/400, MSGW, MSGW status
My Job is in MSGW. I want to know at what time it went in MSGW? For Example- Lets say I submitted a Job at 4 PM and after running for half an hour it went to MSGW at 4:30. So I want to how programatically or by some commad which returns me the time [...]
Answer Question
| March 17, 2012 3:05 PM
AS/400, MSGW, MSGW status
RPGLE AS400
How to create 6 digit non repeating random number in rpgle as400?
Answer Question
| March 17, 2012 9:14 AM
AS400 RPGLE, RPGLE
How to create 6 digit non repeating random number in rpgle as400?
Answer Question
| March 17, 2012 9:14 AM
AS400 RPGLE, RPGLE
Change colour of RPG source header part?
Hi , I want to change colour of source in fallowing format. RPG source header.. * Name - ______________________ (wants marked line with greeen square box) * Text - RPG first program header (wants text colour in white instead of green)
Answer Question
| February 28, 2012 6:10 AM
as/400 rpg iseries, RPG Source
Hi , I want to change colour of source in fallowing format. RPG source header.. * Name - ______________________ (wants marked line with greeen square box) * Text - RPG first program header (wants text colour in white instead of green)
Answer Question
| February 28, 2012 6:10 AM
as/400 rpg iseries, RPG Source
STRPCCMD
Hi Guys, Need some help with the command STRPCCMD. I am using this command in a CL program to display a .pdf document stored on the server. The name of the docment is determined by the Cl prpgram given the user and other parameter. All works well when the document is found in correct place. When [...]
Answer Question
| March 17, 2012 11:24 PM
AS/400, AS400 Cleanup V5R4M0, STRPCCMD command
Hi Guys, Need some help with the command STRPCCMD. I am using this command in a CL program to display a .pdf document stored on the server. The name of the docment is determined by the Cl prpgram given the user and other parameter. All works well when the document is found in correct place. When [...]
Answer Question
| March 17, 2012 11:24 PM
AS/400, AS400 Cleanup V5R4M0, STRPCCMD command
Read record from multi record format LF using RPGLE
is it possible, read records from multi record format LF using RPGLE. if it is possible, how to do this…
Answer Question
| March 17, 2012 3:05 PM
AS/400 Records, AS400 RPGLE, as400 v5r3
is it possible, read records from multi record format LF using RPGLE. if it is possible, how to do this…
Answer Question
| March 17, 2012 3:05 PM
AS/400 Records, AS400 RPGLE, as400 v5r3
Trigger over table that uses transaction inserts
I have a table that is being updated via JDBC. The program that is writing records (sql insert) is using transactions. This table has an after insert trigger on it. When the trigger is disabled the table is updates correctly. When the trigger is on we get the first record and the tigger locks the [...]
Answer Question
| February 28, 2012 5:23 PM
iSeries, JDBC, SQL INSERT, Triggers
I have a table that is being updated via JDBC. The program that is writing records (sql insert) is using transactions. This table has an after insert trigger on it. When the trigger is disabled the table is updates correctly. When the trigger is on we get the first record and the tigger locks the [...]
Answer Question
| February 28, 2012 5:23 PM
iSeries, JDBC, SQL INSERT, Triggers
How to find out existing LF key is ascending or descending order?
How to find out existing LF key is ascending or descending order?
Answer Question
| February 28, 2012 11:50 AM
AS/400
How to find out existing LF key is ascending or descending order?
Answer Question
| February 28, 2012 11:50 AM
AS/400
Spooled Files sent via SNDDST
Our system runs reports at night to an outq. Upon completion of reports a program goes through and converts the spooled files to PDF and emails using SNDDST and then deletes the spooled files. My problem is that last night for whatever reason the program finished successfully without errors and none of the reports were [...]
Answer Question
| March 17, 2012 10:42 PM
SNDDST, Spooled File
Our system runs reports at night to an outq. Upon completion of reports a program goes through and converts the spooled files to PDF and emails using SNDDST and then deletes the spooled files. My problem is that last night for whatever reason the program finished successfully without errors and none of the reports were [...]
Answer Question
| March 17, 2012 10:42 PM
SNDDST, Spooled File
wrkusrprf command irregularities
cmd wrkusrprf goes to “work with user enrollment screen”, not “work with user profiles screen” my user profile has secofr authorities, and I created another user profile like mine, but his wrkusrprf goes to work with user enrollment, while my wrkusrprf goes to work with user profiles. I assume there are differences in how I [...]
Answer Question
| March 17, 2012 10:03 PM
AS/400, WRKUSRPRF
cmd wrkusrprf goes to “work with user enrollment screen”, not “work with user profiles screen” my user profile has secofr authorities, and I created another user profile like mine, but his wrkusrprf goes to work with user enrollment, while my wrkusrprf goes to work with user profiles. I assume there are differences in how I [...]
Answer Question
| March 17, 2012 10:03 PM
AS/400, WRKUSRPRF
Qualified Data Structure with Multiple Occurrance
How do I define a Qualified DS as a *Entry Parm with Multiple Occurrences?
Answer Question
| March 19, 2012 5:21 PM
as/400 rpg iseries, AS400 RPGLE, RPGLE
How do I define a Qualified DS as a *Entry Parm with Multiple Occurrences?
Answer Question
| March 19, 2012 5:21 PM
as/400 rpg iseries, AS400 RPGLE, RPGLE
Client Access Disconnect
I have the latest version of iSeries Access running on a Windows 7 Prof PC and connection to a AS400 running V7.1 through a VPN connection. After establishing a 5250 session I can run any file inquiry RPG program, WRKACTJOB, WRKSPLF etc without a problem. If I run a query400 query, the session disconnects before [...]
Answer Question
| March 19, 2012 4:05 PM
AS400 V7.1, iSeries Access, Windows 7 Professional
I have the latest version of iSeries Access running on a Windows 7 Prof PC and connection to a AS400 running V7.1 through a VPN connection. After establishing a 5250 session I can run any file inquiry RPG program, WRKACTJOB, WRKSPLF etc without a problem. If I run a query400 query, the session disconnects before [...]
Answer Question
| March 19, 2012 4:05 PM
AS400 V7.1, iSeries Access, Windows 7 Professional
Access to iSeries server using iSeries Navigator.
Getting error while accessing iSeries server using iSeries Navigator. Error Details: “system i Navigator was unable to determine which new components 00.00.00.00 is capable of supporting. Refer to the system i Access History Log for more Information.” (Where 00.00.00.00 is the IP address of server.) Note: How can i check the ” System i Access [...]
Answer Question
| March 19, 2012 12:58 PM
AS400 iseries, iSeries Navigator
Getting error while accessing iSeries server using iSeries Navigator. Error Details: “system i Navigator was unable to determine which new components 00.00.00.00 is capable of supporting. Refer to the system i Access History Log for more Information.” (Where 00.00.00.00 is the IP address of server.) Note: How can i check the ” System i Access [...]
Answer Question
| March 19, 2012 12:58 PM
AS400 iseries, iSeries Navigator
SQL Precompiled Failed
In SQLRPG program, when a compile a program it is showing the error SQL Precompiled Failed. I have given the sql syntax correctly. but I cant able to find the error. What may be reason for it? Please clarify. Jayashree V.
Answer Question
| March 19, 2012 1:17 PM
AS/400, AS/400 and SQL, SQLRPG
In SQLRPG program, when a compile a program it is showing the error SQL Precompiled Failed. I have given the sql syntax correctly. but I cant able to find the error. What may be reason for it? Please clarify. Jayashree V.
Answer Question
| March 19, 2012 1:17 PM
AS/400, AS/400 and SQL, SQLRPG
File transfer methods from AS400 server to other servers(mainframe))
I have a requirement where i need to generate a flat file and send it to few of the mainframe servers ,when a new record is added to this file. .Please let me know the possible ways to perform this task and provide the sample code(CL and RPG).
Answer Question
| March 17, 2012 12:14 PM
AS/400, File Transfer
I have a requirement where i need to generate a flat file and send it to few of the mainframe servers ,when a new record is added to this file. .Please let me know the possible ways to perform this task and provide the sample code(CL and RPG).
Answer Question
| March 17, 2012 12:14 PM
AS/400, File Transfer
Prod and Test environment
What is the difference between PROD and TEST environments in AS400
Answer Question
| March 17, 2012 4:16 PM
AS/400, AS/400 testing
What is the difference between PROD and TEST environments in AS400
Answer Question
| March 17, 2012 4:16 PM
AS/400, AS/400 testing
Retrieving package for V6R1
Hi, I have trying hard to retrieve the CUM package for V6R1..I have tried every way I did FTP from OS400 and after 300 MB download of first CUM file it got ended with message TCP/IP unable to receive data, other 2 ptf images were retrived successfully. I have tried to download onmy PC but [...]
Answer Question
| March 17, 2012 5:16 PM
CUM PTFs, Cumulative PTF Package, iSeries V6R1
Hi, I have trying hard to retrieve the CUM package for V6R1..I have tried every way I did FTP from OS400 and after 300 MB download of first CUM file it got ended with message TCP/IP unable to receive data, other 2 ptf images were retrived successfully. I have tried to download onmy PC but [...]
Answer Question
| March 17, 2012 5:16 PM
CUM PTFs, Cumulative PTF Package, iSeries V6R1
Iseries access print screen doesn’t work on Windows 7
Iseries access print screen key doesn’t work on Windows 7. I have no problem on all previous releases back to DOS.
Answer Question
| March 17, 2012 2:46 PM
iSeries Access for Windows
Iseries access print screen key doesn’t work on Windows 7. I have no problem on all previous releases back to DOS.
Answer Question
| March 17, 2012 2:46 PM
iSeries Access for Windows
How do you change the source of printer when printing from AS400
Hello all, we get regular requests to get AS400 prints from a specific tray. I know we can do from wrkdevd, but how does it work from a SPLF perspective. to reach only specific tray in the file
Answer Question
| February 28, 2012 10:38 AM
AS400 printing issue
Hello all, we get regular requests to get AS400 prints from a specific tray. I know we can do from wrkdevd, but how does it work from a SPLF perspective. to reach only specific tray in the file
Answer Question
| February 28, 2012 10:38 AM
AS400 printing issue
AS/400 Client Access.
I am trying to login to server which is hosted outside of my network. (connection method is CISCO Anyconnect.)its giving error while connecting to server. Error details : CWBLM0031 – failure, a data conversion error was returned by the host server. rc1=2 rc2=21
Answer Question
| March 17, 2012 7:02 AM
AS/400 Client Access
I am trying to login to server which is hosted outside of my network. (connection method is CISCO Anyconnect.)its giving error while connecting to server. Error details : CWBLM0031 – failure, a data conversion error was returned by the host server. rc1=2 rc2=21
Answer Question
| March 17, 2012 7:02 AM
AS/400 Client Access
Issue with HMC backup
Hi This is my first trail ……I followed the following process to take backup for the HMC… From HMC Software Maintainance —> HMC—->Backup critical console data—->backup to DVD on local system. Here I am getting problem with media and giving error like not a compatable disk. Also asking for a farmat the DISK. For this [...]
Answer Question
| May 15, 2012 7:20 PM
AS/400 administration, HMC V6.1
Hi This is my first trail ……I followed the following process to take backup for the HMC… From HMC Software Maintainance —> HMC—->Backup critical console data—->backup to DVD on local system. Here I am getting problem with media and giving error like not a compatable disk. Also asking for a farmat the DISK. For this [...]
Answer Question
| May 15, 2012 7:20 PM
AS/400 administration, HMC V6.1
