DB2/400
Why do I need logical file in DB2/400?
Answer Question
| October 23, 2012 3:18 PM
AS/400 DB2, AS/400 logical file
Why do I need logical file in DB2/400?
update replace
I’m trying to update a particular text string in a long trxt eg 505400005004GBP23800280000 trying to replace the 10th char 0 with a 1 how can I do this please, thanks
Answer Question
| June 26, 2012 5:06 PM
AS/400 DB2
I’m trying to update a particular text string in a long trxt eg 505400005004GBP23800280000 trying to replace the 10th char 0 with a 1 how can I do this please, thanks
pass array to clle
i created RPGLE,within that i defined compiled time array now i want to pass that array (at a time only one insex) to cllle but while i run this rpgle its give me run time error ..that Error occurred while calling program or procedure *LIBL/practcl8 Message ID . . . . . . : [...]
Answer Question
| April 16, 2012 4:44 AM
AS/400 DB2, AS400 iseries, iSeries RPGLE
i created RPGLE,within that i defined compiled time array now i want to pass that array (at a time only one insex) to cllle but while i run this rpgle its give me run time error ..that Error occurred while calling program or procedure *LIBL/practcl8 Message ID . . . . . . : [...]
Logical file Error.
i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A R RDEPTMST A DEPTNAME 15 A DID [...]
Answer Question
| April 17, 2012 6:20 AM
AS/400 DB2, Logical File
i try to create Multiple-format Logical File but i getting compile time error. i have two PF dds is as follow.. A R RDEPTMST A DEPTNAME 15 A DID [...]
Synon (Migration)
Dear Friends, We are in a plan of migrating system to some other technology like Java/.NET etc. Please find the details and questions below. Information about the current System: Synon (CA -2E) 8.5 Version Few modules the source is getting generated in COBOL and other in RPG Database we using DB2/400 Questions: What all should [...]
Answer Question
| March 17, 2012 6:55 AM
AS/400 DB2, AS/400 Synon, RPG Data Fields
Dear Friends, We are in a plan of migrating system to some other technology like Java/.NET etc. Please find the details and questions below. Information about the current System: Synon (CA -2E) 8.5 Version Few modules the source is getting generated in COBOL and other in RPG Database we using DB2/400 Questions: What all should [...]
Using Dropbox and Radio button with DB2400
IS THAT POSSIBLE OF USING DROPBOX AND RADIO BUTTON IN DB2400?
Answer Question
| March 31, 2012 9:31 AM
AS/400 DB2, DB2/400, Dropbox, Radio buttons
IS THAT POSSIBLE OF USING DROPBOX AND RADIO BUTTON IN DB2400?
VSAM versus DB2 in CPU consumption
Is it possible estimate how much more CPU is consumed by DB2 commands in relation to VSAM KSDS when access a row, through an index scan, in a organized DB2 table against a record reading from an organized VSAM KSDS file through the primary index? How much is it in percentage? Thank you very much [...]
Answer Question
| March 31, 2012 3:57 PM
AS/400 DB2, DB2, VSAM, z/OS CPU consumption
Is it possible estimate how much more CPU is consumed by DB2 commands in relation to VSAM KSDS when access a row, through an index scan, in a organized DB2 table against a record reading from an organized VSAM KSDS file through the primary index? How much is it in percentage? Thank you very much [...]
Connecting SAP to iSeries.
We are undergoing a project implementation in which we need to connect SAP to iSeries where SAP would be the target for fetching data from iSeries which is the source. Can anyone help me by providing the steps involved for Connecting SAP to iSeries. Also let me know if any addtional product is to be installed [...]
Answer Question
| March 31, 2012 7:40 AM
AS/400 DB2, iSeries connectivity, SAP, SAP connectivity
We are undergoing a project implementation in which we need to connect SAP to iSeries where SAP would be the target for fetching data from iSeries which is the source. Can anyone help me by providing the steps involved for Connecting SAP to iSeries. Also let me know if any addtional product is to be installed [...]
Switch between two screens using CICS maps
how we can switch between two screens using maps in cics what will be the logic implemented in cobol programme?
Answer Question
| March 31, 2012 2:16 AM
AS/400 DB2, CICS, CICS programs, COBOL
how we can switch between two screens using maps in cics what will be the logic implemented in cobol programme?
Not able to create procedures using STRSQL on V6R1
While creating a procedure in V6R1, [strong]Not authorized to CREATE PROCEDURE error (Message ID is SQL0552)[/strong] appears. In Additional Message Information cause of the error being — [strong]CREATE PROCEDURE or CREATE FUNCTION requires the *OBJOPR and *ADD authority to the catalog table SYSROUTINES in QSYS2[/strong]. However [strong]PUBLIC[/strong] has [strong]*CHANGE[/strong] Authority on [strong]QSYS2/SYSROUTINE[/strong] Object. Please note my [...]
Answer Question
| March 31, 2012 7:22 AM
AS/400 DB2, AS/400 SQL, iSeries V6R1, STRSQL
While creating a procedure in V6R1, [strong]Not authorized to CREATE PROCEDURE error (Message ID is SQL0552)[/strong] appears. In Additional Message Information cause of the error being — [strong]CREATE PROCEDURE or CREATE FUNCTION requires the *OBJOPR and *ADD authority to the catalog table SYSROUTINES in QSYS2[/strong]. However [strong]PUBLIC[/strong] has [strong]*CHANGE[/strong] Authority on [strong]QSYS2/SYSROUTINE[/strong] Object. Please note my [...]
Moving file from Linux to AS/400
how can i get a file from linux to my as400 use to do it with Client Assist but being told that does not exist in linux !
Answer Question
| March 31, 2012 2:55 PM
AS/400 DB2, AS/400 to Linux OS, DB2/400, Linux, Linux file system
how can i get a file from linux to my as400 use to do it with Client Assist but being told that does not exist in linux !
What are the steps needs to be followed while removing Key Fields from PF.
Hi, i have got a requirement to remove the Key Fields from the PF. Can anybody please suggest what are all the sequence of steps i shd follow to incorporate this changes to avoid any issues in Production after change. As per my knowledge below are the steps i am planning to follow, please confirm. [...]
Answer Question
| March 31, 2012 5:43 AM
AS/400 DB2, AS400 physical file, DB2/400, Physical Files
Hi, i have got a requirement to remove the Key Fields from the PF. Can anybody please suggest what are all the sequence of steps i shd follow to incorporate this changes to avoid any issues in Production after change. As per my knowledge below are the steps i am planning to follow, please confirm. [...]
Compare files in AS400
When i compare two files using CMPPFM command, i am getting message as request failed. This is because files were having huge volume of data. It was showing file exceeds 112498 records. Is there any other way to compare files of large volume of data in AS400. Please let me know.
Answer Question
| June 7, 2011 6:42 PM
AS/400 command functions, AS/400 DB2, AS/400 File Sharing, CMPPFM
When i compare two files using CMPPFM command, i am getting message as request failed. This is because files were having huge volume of data. It was showing file exceeds 112498 records. Is there any other way to compare files of large volume of data in AS400. Please let me know.
How to sort a db2 table column, containing date stored in char format.
i have a column which is not Y2K complaint, the values are stored in char format like ddmmyy ( i know its totally dumb), i need to sort based on ascending or descending order. 051193 -> 5 nov 1993 140308 -> 14 march 2008 141211 -> 14 december 2011 Now how do i sort this [...]
Answer Question
| May 21, 2011 5:01 PM
AS/400 DB2, DB2, DB2 Table
i have a column which is not Y2K complaint, the values are stored in char format like ddmmyy ( i know its totally dumb), i need to sort based on ascending or descending order. 051193 -> 5 nov 1993 140308 -> 14 march 2008 141211 -> 14 december 2011 Now how do i sort this [...]
DB2 Process automatically Shutdown
At our site using IBM DB2 database there some problem with our DB2 Database services stop automatically .Error log shown the DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Thanks, Nilesh
Answer Question
| May 13, 2011 8:51 AM
AS/400 database, AS/400 database administration, AS/400 DB2, DB2
At our site using IBM DB2 database there some problem with our DB2 Database services stop automatically .Error log shown the DB2 PROCESSES ASSOCIATED WITH THIS INSTANCE HAVE BEEN SHUTDOWN. Thanks, Nilesh
Can we change length of CSV File
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the [...]
Answer Question
| May 11, 2011 11:22 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the [...]
Inserting and viewing of Chinese characters in DB2400
Dear All, We are trying to insert Chinese characters into an AS400 PF. We originally had the CCSID of the PF field as 13488, The job CCSID being 65535 HOWERVER when we are trying to input characters, it is taking as ????????? Later, we careated a new file – with CCSID 1200 and still the [...]
Answer Question
| May 5, 2011 5:35 PM
AS/400 DB2, CCSID, DB2, DB2 administration
Dear All, We are trying to insert Chinese characters into an AS400 PF. We originally had the CCSID of the PF field as 13488, The job CCSID being 65535 HOWERVER when we are trying to input characters, it is taking as ????????? Later, we careated a new file – with CCSID 1200 and still the [...]
SQL equivalent of GRTOBJAUT using Authorization List
Using SQL script, how does one grant object authority to a table using an authorization list? This fails because MyAutList is not a *USRPRF: grant all on table mylib.mytable to MyAutList This works, but is not what I need: grant all on table mylib.mytable to Public
Answer Question
| May 2, 2011 5:03 PM
AS/400 DB2, Object authority, SQL Server, USRPRF
Using SQL script, how does one grant object authority to a table using an authorization list? This fails because MyAutList is not a *USRPRF: grant all on table mylib.mytable to MyAutList This works, but is not what I need: grant all on table mylib.mytable to Public
DB2 Tuning link or manual for AS400
Hi, In the company I work for we have a requeriment for tuning DB2 in as400. We still don’t know the server release, but I wanted to start searching for any documentation about that. I will appreciate any link or suggestions. Thank you. Regards.
Answer Question
| April 15, 2011 3:14 PM
AS/400, AS/400 DB2, DB2
Hi, In the company I work for we have a requeriment for tuning DB2 in as400. We still don’t know the server release, but I wanted to start searching for any documentation about that. I will appreciate any link or suggestions. Thank you. Regards.
SQL Update Set: Higlight Customers without Invoices, Update and join Tables?
Hello, I am not sure how to do this with an SQL Update Set statemet: I have a table customers and I have related invoices. I would like to set one field to “not active” in the customer table that did not receive invoices since 2008. I can “Select” the corresponding records in the customer table [...]
Answer Question
| March 28, 2011 2:03 PM
AS/400 DB2, DB2, SQL statement
Hello, I am not sure how to do this with an SQL Update Set statemet: I have a table customers and I have related invoices. I would like to set one field to “not active” in the customer table that did not receive invoices since 2008. I can “Select” the corresponding records in the customer table [...]





