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 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 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
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
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…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
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
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
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 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
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 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
Can you do a unattended install of Client Access?
Answer Question | January 24, 2013 4:08 PM
Client Access, Client Access Installation
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 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
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
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
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
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
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