About EVAL OPCODE
I have a field which is declared as alphanumeric and the default value for the variable is blank. Now I have declared one more variable which is of zoned decimal type. Now I want to move the value in the alphanumeric variable which is blank into the field, which is declared as zoned decimal. Will [...]
Answer Question
| March 21, 2013 11:01 AM
AS/400, AS/400 Fields
I have a field which is declared as alphanumeric and the default value for the variable is blank. Now I have declared one more variable which is of zoned decimal type. Now I want to move the value in the alphanumeric variable which is blank into the field, which is declared as zoned decimal. Will [...]
Answer Question
| March 21, 2013 11:01 AM
AS/400, AS/400 Fields
24 digit number: Arithmetic operations?
Hi, I need to work with numbers which are digits long. Why? Because this is the way to create a German IBAN code from Bank Code and Bank account: Concatenate Bank Code (8 digits) plus Account nbr (10 digits, leading zeroes) plus “131400″ to a 24 digit number. Compute Modulo 97 of this number. (or [...]
Answer Question
| March 21, 2013 8:03 AM
COBOL/400, IBMi, RPG
Hi, I need to work with numbers which are digits long. Why? Because this is the way to create a German IBAN code from Bank Code and Bank account: Concatenate Bank Code (8 digits) plus Account nbr (10 digits, leading zeroes) plus “131400″ to a 24 digit number. Compute Modulo 97 of this number. (or [...]
Answer Question
| March 21, 2013 8:03 AM
COBOL/400, IBMi, RPG
Retrieving the name of a file from object links
We are receiving a Daily file containing Chassis information via FTP at a scheduled time in the early morning. I have written a process to automatically retrieve this file, CPYFRMIMPF to my Physical File, then process the data into our Chassis Master. Originally, I was told it would be a specific and constant name so [...]
Answer Question
| March 20, 2013 11:55 AM
AS/400, CPYFRMIMPF, RPGLE
We are receiving a Daily file containing Chassis information via FTP at a scheduled time in the early morning. I have written a process to automatically retrieve this file, CPYFRMIMPF to my Physical File, then process the data into our Chassis Master. Originally, I was told it would be a specific and constant name so [...]
Answer Question
| March 20, 2013 11:55 AM
AS/400, CPYFRMIMPF, RPGLE
Arrays in AS/400
I declared an array which is of character data type and I want to overlay an element in the array which is of decimal type. Is it possible to overlay an element which is of decimal type (zoned) in to an array which is declared as character one? The code of the following issue is [...]
Answer Question
| March 20, 2013 8:50 AM
AS/400, AS/400 Arrays
I declared an array which is of character data type and I want to overlay an element in the array which is of decimal type. Is it possible to overlay an element which is of decimal type (zoned) in to an array which is declared as character one? The code of the following issue is [...]
Answer Question
| March 20, 2013 8:50 AM
AS/400, AS/400 Arrays
SQL insert error in php
When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here’s [...]
Answer Question
| March 19, 2013 9:20 PM
AS/400, DB2, PHP, SQL
When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here’s [...]
Answer Question
| March 19, 2013 9:20 PM
AS/400, DB2, PHP, SQL
Getting DB2 data into SQL 2008 database
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged [...]
Answer Question
| March 20, 2013 7:59 PM
AS/400, DB2, iSeries, SQL 2008
We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged [...]
Answer Question
| March 20, 2013 7:59 PM
AS/400, DB2, iSeries, SQL 2008
Disk percentage
If current ASP is 65% used from 10TB and if 1TB is removed from the rack how much ASP percentage would get increased? I said it is 75%. Can anyone improve this answer?
Answer Question
| March 19, 2013 4:33 PM
AS/400, AS/400 ASP
If current ASP is 65% used from 10TB and if 1TB is removed from the rack how much ASP percentage would get increased? I said it is 75%. Can anyone improve this answer?
Answer Question
| March 19, 2013 4:33 PM
AS/400, AS/400 ASP
About EVALR Opcode
Could anyone let me know what is an EVALR Opcode in AS/400? If possible, can anyone give me some sample code which is on EVALR Opcode?
Answer Question
| March 19, 2013 9:16 AM
AS/400, RPGLE
Could anyone let me know what is an EVALR Opcode in AS/400? If possible, can anyone give me some sample code which is on EVALR Opcode?
Answer Question
| March 19, 2013 9:16 AM
AS/400, RPGLE
AS/400
How can we remove the two years back data from our table? We don’t have any time stamp in a table. Please let me know the process to achieve it. Thanks, Ravula
Answer Question
| March 19, 2013 7:48 AM
AS/400, AS/400 tables
How can we remove the two years back data from our table? We don’t have any time stamp in a table. Please let me know the process to achieve it. Thanks, Ravula
Answer Question
| March 19, 2013 7:48 AM
AS/400, AS/400 tables
Recovering objects without object detail
How to get the saved object details from the backup tape, when the library which contains the objects is saved without object level details.
Answer Question
| March 19, 2013 6:39 AM
BRMS, BRMS Backup
How to get the saved object details from the backup tape, when the library which contains the objects is saved without object level details.
Answer Question
| March 19, 2013 6:39 AM
BRMS, BRMS Backup
RPG – Roll your own level breaks
Has anyone every heard of ‘Roll your own Level Breaks’ in RPG? Can you enlighten me on how it works? I have to mimic a program that does this already with a different set of data. Here is a basic overview of the application. A selection screen allows you to select a date range, region, [...]
Answer Question
| March 19, 2013 9:04 PM
AS/400, RPG, SQLRPGLE
Has anyone every heard of ‘Roll your own Level Breaks’ in RPG? Can you enlighten me on how it works? I have to mimic a program that does this already with a different set of data. Here is a basic overview of the application. A selection screen allows you to select a date range, region, [...]
Answer Question
| March 19, 2013 9:04 PM
AS/400, RPG, SQLRPGLE
ALCOBJ on a Data area
Hi , I have one program which starts a job , I do ALCOBJ on a dataarea so that if the job is already running and someone tries to start the job again i can show the error that job is running ALCOBJ OBJ((&LIBLDTAQ/&DTAAA *DTAARA *EXCL)) WAIT(0) MONMSG MSGID(CPF1002) EXEC(DO) SNDPGMMSG MSG(‘Mikaodo Job Schedular is [...]
Answer Question
| March 18, 2013 12:07 PM
Allocate Object, AS400 Command, Data Area
Hi , I have one program which starts a job , I do ALCOBJ on a dataarea so that if the job is already running and someone tries to start the job again i can show the error that job is running ALCOBJ OBJ((&LIBLDTAQ/&DTAAA *DTAARA *EXCL)) WAIT(0) MONMSG MSGID(CPF1002) EXEC(DO) SNDPGMMSG MSG(‘Mikaodo Job Schedular is [...]
Answer Question
| March 18, 2013 12:07 PM
Allocate Object, AS400 Command, Data Area
About AS/400
I have an object library and my source code is in object library and the files which are opened in output/update mode in the PGM are in my object library and the file which is opened in input mode is in another object library. Now I included two object libraries to my library list and [...]
Answer Question
| March 18, 2013 11:50 AM
AS/400, AS/400 error messages
I have an object library and my source code is in object library and the files which are opened in output/update mode in the PGM are in my object library and the file which is opened in input mode is in another object library. Now I included two object libraries to my library list and [...]
Answer Question
| March 18, 2013 11:50 AM
AS/400, AS/400 error messages
CLP Programming
PGM DCLF FILE(AMITLIB/STUDPF) LOOP: RCVF RCDFMT(STUDRRC) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) SNDUSRMSG MSG(&NAME) OPNQRYF FILE((AMITLIB/STUDPF)) QRYSLT(*ALL) GOTO CMDLBL(LOOP) END: ENDPGM it displays only the first data in the file. how to display all the records present in the file?
Answer Question
| March 18, 2013 9:47 AM
CL programming, CLP
PGM DCLF FILE(AMITLIB/STUDPF) LOOP: RCVF RCDFMT(STUDRRC) MONMSG MSGID(CPF0864) EXEC(GOTO CMDLBL(END)) SNDUSRMSG MSG(&NAME) OPNQRYF FILE((AMITLIB/STUDPF)) QRYSLT(*ALL) GOTO CMDLBL(LOOP) END: ENDPGM it displays only the first data in the file. how to display all the records present in the file?
Answer Question
| March 18, 2013 9:47 AM
CL programming, CLP
File Status 90 during open
Hi, I have a logical file, which I am trying to open in I-O mode, but I get File status 90 File is existing on the system, The code was working fine previously (on development machine), but today I installed all the objects on another machine (Testing machine), and I am getting this file status, [...]
Answer Question
| March 18, 2013 5:39 AM
AS/400, COBOL
Hi, I have a logical file, which I am trying to open in I-O mode, but I get File status 90 File is existing on the system, The code was working fine previously (on development machine), but today I installed all the objects on another machine (Testing machine), and I am getting this file status, [...]
Answer Question
| March 18, 2013 5:39 AM
AS/400, COBOL
PTF on AS/400 not getting installed and applied
While applying PTF’s SI38079 AND SI38080 for V7R1, it keeps coming back as not installed.
Answer Question
| March 15, 2013 4:19 PM
AS/400, PTF
While applying PTF’s SI38079 AND SI38080 for V7R1, it keeps coming back as not installed.
Answer Question
| March 15, 2013 4:19 PM
AS/400, PTF
List of users who are members of a group profile
How do I create report that show a list of users who are members of an AS/400 group profile?
Answer Question
| March 15, 2013 4:01 PM
AS/400, AS/400 User Groups
How do I create report that show a list of users who are members of an AS/400 group profile?
Answer Question
| March 15, 2013 4:01 PM
AS/400, AS/400 User Groups
About library list in AS/400
Hi, there is a source library for me where I created a module and I binded it to a program with the command ‘CRTPGM’. Now I have created the object of that module in the object library. Now my question is how do I need to organize the library list when the things are as [...]
Answer Question
| March 15, 2013 4:10 AM
AS/400, AS/400 Library
Hi, there is a source library for me where I created a module and I binded it to a program with the command ‘CRTPGM’. Now I have created the object of that module in the object library. Now my question is how do I need to organize the library list when the things are as [...]
Answer Question
| March 15, 2013 4:10 AM
AS/400, AS/400 Library
About AS/400
A file is opened in a program in input mode and he turned the parameter ‘file addition’ to ‘A’. My doubt is, is it possible to add a record to the file thru the program when the file is opened in input mode?
Answer Question
| March 15, 2013 4:00 AM
AS/400, AS/400 Records
A file is opened in a program in input mode and he turned the parameter ‘file addition’ to ‘A’. My doubt is, is it possible to add a record to the file thru the program when the file is opened in input mode?
Answer Question
| March 15, 2013 4:00 AM
AS/400, AS/400 Records
Add a new field in PF
Is it possible to add a new field in an existing PF without deleting the records that are present in it?
Answer Question
| March 14, 2013 12:59 PM
Physical Files, RPG
Is it possible to add a new field in an existing PF without deleting the records that are present in it?
Answer Question
| March 14, 2013 12:59 PM
Physical Files, RPG
