Validate SQL and display the output
I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether [...]
Answer Question
| January 29, 2013 8:14 AM
SQL Query, SQL scripts, SQLRPGLE
I have a screen where the user can enter an SQL script, I need to validate whether the SQL query is a valid one, if so then display the output on to the screen. I am planning to execute a SQL prepare statement out of the script entered and then use SQLCOD to determine whether [...]
Answer Question
| January 29, 2013 8:14 AM
SQL Query, SQL scripts, SQLRPGLE
Question is about ILERPG
I have been given a module name and I’m asked to find out the name of the service programs which included that module. Is there any possible way to find it?
Answer Question
| January 29, 2013 7:27 AM
AS/400, AS/400 commands, ILERPG
I have been given a module name and I’m asked to find out the name of the service programs which included that module. Is there any possible way to find it?
Answer Question
| January 29, 2013 7:27 AM
AS/400, AS/400 commands, ILERPG
Single page subfile with filter
I have a single page subfile which has two fields, ‘Account’ and ‘description’. The subfile is displayed from File1 which has account(key) but doesn’t have description. I am fetching description from another file based on the ‘account’. Now in the subfile I want to include a filter or a ‘position to’(any of the one will [...]
Answer Question
| January 29, 2013 7:13 AM
AS/400, AS/400 Subfiles
I have a single page subfile which has two fields, ‘Account’ and ‘description’. The subfile is displayed from File1 which has account(key) but doesn’t have description. I am fetching description from another file based on the ‘account’. Now in the subfile I want to include a filter or a ‘position to’(any of the one will [...]
Answer Question
| January 29, 2013 7:13 AM
AS/400, AS/400 Subfiles
How can I direct Interactive jobs to specific subsystems?
We have 2 interactive subsystems. One was intended for all the interactive jobs of the IT department. The other was for all non-IT users. The idea being – if necessary, the non-IT user subsystem could be ended while IT people were still logged on fixing a problem or whatever. When interactive sessions are started the [...]
Answer Question
| January 28, 2013 4:42 PM
AS/400, AS/400 subsystem
We have 2 interactive subsystems. One was intended for all the interactive jobs of the IT department. The other was for all non-IT users. The idea being – if necessary, the non-IT user subsystem could be ended while IT people were still logged on fixing a problem or whatever. When interactive sessions are started the [...]
Answer Question
| January 28, 2013 4:42 PM
AS/400, AS/400 subsystem
RPG Programmer
I am IT consultant and have worked on two short contracts for clients based in Melbourne(Australia) as RPG Programmer for a period of 10 months. One client is into Fleet Leasing and another one is in Superannuation. Along with this I have also worked as Technical Support assistant and happen to get some basic experience [...]
Answer Question
| January 28, 2013 1:30 PM
AS/400, AS/400 training
I am IT consultant and have worked on two short contracts for clients based in Melbourne(Australia) as RPG Programmer for a period of 10 months. One client is into Fleet Leasing and another one is in Superannuation. Along with this I have also worked as Technical Support assistant and happen to get some basic experience [...]
Answer Question
| January 28, 2013 1:30 PM
AS/400, AS/400 training
How to limit exact file name for data access on AS/400 through ODBC
How to limit exact file name…we need the restrict exact file name (not at all) when our user use data access on AS/400 through ODBC.
Answer Question
| January 28, 2013 7:17 AM
AS/400, ODBC
How to limit exact file name…we need the restrict exact file name (not at all) when our user use data access on AS/400 through ODBC.
Answer Question
| January 28, 2013 7:17 AM
AS/400, ODBC
Long field in display file
I have a display file which has a long field which is meant to hold a SQL query. The field is assumed to appear in the screen as 16 lines, with 68A per line. So When I declared a field of length 1088A(16*68) but how can I declare it to have only 68 per line [...]
Answer Question
| January 28, 2013 7:16 AM
AS/400, DSPF, SQL Query
I have a display file which has a long field which is meant to hold a SQL query. The field is assumed to appear in the screen as 16 lines, with 68A per line. So When I declared a field of length 1088A(16*68) but how can I declare it to have only 68 per line [...]
Answer Question
| January 28, 2013 7:16 AM
AS/400, DSPF, SQL Query
How to find the OS/400 version from web based HMC?
Hello, I had an issue like all the LPARs were down and I can only access the frame through Web based HMC. Is there any way to find the OS level through this interface? Thanks.
Answer Question
| January 28, 2013 8:01 AM
AS/400, HMC, OS/400
Hello, I had an issue like all the LPARs were down and I can only access the frame through Web based HMC. Is there any way to find the OS level through this interface? Thanks.
Answer Question
| January 28, 2013 8:01 AM
AS/400, HMC, OS/400
DTF to Excel in Batch file
I have a Batch file (run from icon on desktop) that is running an IBM DTF to and Excel spreadsheet (file type: ASCII TEXT, translate data: ASCII) and then I use start excel.exe and it opens my spreadsheet with the data. PROBLEM: How can I format the spreadsheet with headers and column fonts and colors, [...]
Answer Question
| January 25, 2013 7:20 PM
Batch file, DTF, Microsoft Excel
I have a Batch file (run from icon on desktop) that is running an IBM DTF to and Excel spreadsheet (file type: ASCII TEXT, translate data: ASCII) and then I use start excel.exe and it opens my spreadsheet with the data. PROBLEM: How can I format the spreadsheet with headers and column fonts and colors, [...]
Answer Question
| January 25, 2013 7:20 PM
Batch file, DTF, Microsoft Excel
CPYFRMIMPF returning blank records
I am using CPYFRMIMPF to copy a flat text file to an AS/400 physical file. The copy is occurring, but the records are blank. The physical file contains the correct number of records after the copy, but the data is blank. Below is the command with parms. CPYFRMIMPF FROMSTMF(‘/Interfaces/OCSEA/RS671WF@’) + TOFILE(RS671WFI) MBROPT(*ADD) + STMFLEN(2046) FROMCCSID(819) [...]
Answer Question
| January 28, 2013 5:27 PM
AS/400, CPYFRMIMPF, Physical File
I am using CPYFRMIMPF to copy a flat text file to an AS/400 physical file. The copy is occurring, but the records are blank. The physical file contains the correct number of records after the copy, but the data is blank. Below is the command with parms. CPYFRMIMPF FROMSTMF(‘/Interfaces/OCSEA/RS671WF@’) + TOFILE(RS671WFI) MBROPT(*ADD) + STMFLEN(2046) FROMCCSID(819) [...]
Answer Question
| January 28, 2013 5:27 PM
AS/400, CPYFRMIMPF, Physical File
How to assign a job to a particular subsystem?
Can anyone please let me know how to assign a job to a particular subsystem? Say I have 2 jobs. Job1 -should be driven to subsystem1 & job2 to subsystem2. I don’t have any requirement in specific but just wanted to know how to accomplish this.
Answer Question
| January 25, 2013 4:39 AM
AS/400, AS/400 subsystem
Can anyone please let me know how to assign a job to a particular subsystem? Say I have 2 jobs. Job1 -should be driven to subsystem1 & job2 to subsystem2. I don’t have any requirement in specific but just wanted to know how to accomplish this.
Answer Question
| January 25, 2013 4:39 AM
AS/400, AS/400 subsystem
What is the main difference between Subsystem & Activation Group
What is the basic difference between an activation group and a subsystem? I have tried reading couple of blogs but I get confused. Can anyone please help me with this?
Answer Question
| January 25, 2013 3:22 AM
Activation Groups, Subsystems
What is the basic difference between an activation group and a subsystem? I have tried reading couple of blogs but I get confused. Can anyone please help me with this?
Answer Question
| January 25, 2013 3:22 AM
Activation Groups, Subsystems
Unattended install of Client Access
Can you do a unattended install of Client Access?
Answer Question
| January 24, 2013 4:08 PM
Client Access, Client Access Installation
Can you do a unattended install of Client Access?
Answer Question
| January 24, 2013 4:08 PM
Client Access, Client Access Installation
AS/400 pass through query from Microsoft Access
I am trying to build a pass through query in Microsoft Access. I am trying to retrieve data from a file that has multiple file formats. Here is the code I have so far in my pass through query: SELECT h.lhamt1 balance, h.lhnote account FROM bnkprd01.lnp007 h WHERE h.lhtc1 = 33 AND h.lhposj BETWEEN 2012336 [...]
Answer Question
| January 24, 2013 2:45 PM
AS/400, Microsoft Access
I am trying to build a pass through query in Microsoft Access. I am trying to retrieve data from a file that has multiple file formats. Here is the code I have so far in my pass through query: SELECT h.lhamt1 balance, h.lhnote account FROM bnkprd01.lnp007 h WHERE h.lhtc1 = 33 AND h.lhposj BETWEEN 2012336 [...]
Answer Question
| January 24, 2013 2:45 PM
AS/400, Microsoft Access
Retain the values in the inital screen after coming back from the popup window
I have a screen which displays the account numbers. If i input some values to this account field and when i do an F5(without hitting enter) I can see the popup window, but after coming back from the pop up screen, my account numbers are gone. I have used CA05 for the popup. If I [...]
Answer Question
| January 24, 2013 2:15 PM
AS/400, DSPF
I have a screen which displays the account numbers. If i input some values to this account field and when i do an F5(without hitting enter) I can see the popup window, but after coming back from the pop up screen, my account numbers are gone. I have used CA05 for the popup. If I [...]
Answer Question
| January 24, 2013 2:15 PM
AS/400, DSPF
Any keyword to show a line on the subfile (Window subfile) after the heading?
In my Window subfile, after writing all the header part, I want to show a line. Instead of coding 5 1′———————-’ is there any other keyword for that?
Answer Question
| January 24, 2013 1:11 PM
AS/400, Subfiles
In my Window subfile, after writing all the header part, I want to show a line. Instead of coding 5 1′———————-’ is there any other keyword for that?
Answer Question
| January 24, 2013 1:11 PM
AS/400, Subfiles
Changes that could affect intial menu to override Authorization list for a user profile?
Recently, In our shop we noticed that a particular user profile has access to some of the restricted libraries. We are using Infinium ERP, and have AMCIU intial menu. Somehow, this appears to be broken due to which this user is able to update some of the restricted libraries. I want to know how this [...]
Answer Question
| January 24, 2013 12:33 PM
AS/400, AS/400 user profiles, Infinium
Recently, In our shop we noticed that a particular user profile has access to some of the restricted libraries. We are using Infinium ERP, and have AMCIU intial menu. Somehow, this appears to be broken due to which this user is able to update some of the restricted libraries. I want to know how this [...]
Answer Question
| January 24, 2013 12:33 PM
AS/400, AS/400 user profiles, Infinium
Popup window is not displaying any field values in subfile
I have a requirement like this. From my display file, when an F5 is taken, it should display a subfile. It is displaying the window with the SFLCTL fields, but no values for the subfile field. Can anyone help me here to identify the problem? This is the DSPF code A S@PRODD5 70A O 8 [...]
Answer Question
| January 24, 2013 9:20 AM
AS/400, AS/400 Subfiles
I have a requirement like this. From my display file, when an F5 is taken, it should display a subfile. It is displaying the window with the SFLCTL fields, but no values for the subfile field. Can anyone help me here to identify the problem? This is the DSPF code A S@PRODD5 70A O 8 [...]
Answer Question
| January 24, 2013 9:20 AM
AS/400, AS/400 Subfiles
Printer file
Is printer file a object? If so then please tell me the object type.
Answer Question
| January 24, 2013 7:26 AM
AS/400, AS/400 Printer File
Is printer file a object? If so then please tell me the object type.
Answer Question
| January 24, 2013 7:26 AM
AS/400, AS/400 Printer File
Physical file
While compiling physical file, it is submitted to Batch. I don’t want to submit to Batch. Please give me a solution.
Answer Question
| January 24, 2013 6:37 AM
AS/400, Physical File
While compiling physical file, it is submitted to Batch. I don’t want to submit to Batch. Please give me a solution.
Answer Question
| January 24, 2013 6:37 AM
AS/400, Physical File
