How to download data from DB2/400 table
Can someone tell me how does the unload utility work in DB2/400? I need to download data from a DB2 table to a text file.
Answer Question
| January 23, 2013 11:50 AM
DB2/400, unload utility
Can someone tell me how does the unload utility work in DB2/400? I need to download data from a DB2 table to a text file.
Answer Question
| January 23, 2013 11:50 AM
DB2/400, unload utility
Alternative name of Physical file
How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.
Answer Question
| November 7, 2012 5:11 PM
AS 400, DB2/400, Physical File
How to rename an alternative name(long name) in a physical file using sql or any other method.(Alternative name if present can be found using DSPFD) . No source is available for this physical file and only object is available.
Answer Question
| November 7, 2012 5:11 PM
AS 400, DB2/400, Physical File
How to reduce the time taken to select the records from huge keyed physical file having 180 Million records
Hi All, I have a report program which uses the OPNQRYF to select the records to generate a report based on user selection in display screen, but it is taking lot of time (20 to 30 minuates) to select the records and write write into output file. I am accessing keyed logical file based on [...]
Answer Question
| October 2, 2012 3:23 PM
AS400 Command, DB2/400, Physical File
Hi All, I have a report program which uses the OPNQRYF to select the records to generate a report based on user selection in display screen, but it is taking lot of time (20 to 30 minuates) to select the records and write write into output file. I am accessing keyed logical file based on [...]
Answer Question
| October 2, 2012 3:23 PM
AS400 Command, DB2/400, Physical File
Looking for a db2/400 class in canada
Hi, I am looking for a db2/400 training class in canada. i am not able to find any training class on the web. i am an oracle dba ane my boss wants me to get trained for db2/400 because we bought a company that is using it. Thanks.
Answer Question
| August 24, 2012 2:12 PM
DB2/400
Hi, I am looking for a db2/400 training class in canada. i am not able to find any training class on the web. i am an oracle dba ane my boss wants me to get trained for db2/400 because we bought a company that is using it. Thanks.
Answer Question
| August 24, 2012 2:12 PM
DB2/400
Read the data from PF between dates
I want to read the all the record from the pf which are between some dates Eg: A PF has one year data let say 2011 year data, I want to read all the records from that pf which are from 01/03/2011 to 05/06/2011 dates. the PF fields are DATE,NAME,ADDRESS,P_no. Can anyone help me how [...]
Answer Question
| August 22, 2012 1:06 PM
AS/400, AS/400 programming, DB2/400, RPGLE
I want to read the all the record from the pf which are between some dates Eg: A PF has one year data let say 2011 year data, I want to read all the records from that pf which are from 01/03/2011 to 05/06/2011 dates. the PF fields are DATE,NAME,ADDRESS,P_no. Can anyone help me how [...]
Answer Question
| August 22, 2012 1:06 PM
AS/400, AS/400 programming, DB2/400, RPGLE
Title changing
Hi Group, As per the new assignment i need to change the title from “MQM Application Business” to “ABC”. I have identified the list of Programs and files where I need to change. The list includes RPG, CLP, CBL, CBLLE, CLLE, RPGLE, PRTF, DSPF & DDS files. I have question: 1. What are the factors [...]
Answer Question
| August 18, 2012 6:02 AM
AS/400, CL/400, DB2/400, DSPF, ILE, Printer files
Hi Group, As per the new assignment i need to change the title from “MQM Application Business” to “ABC”. I have identified the list of Programs and files where I need to change. The list includes RPG, CLP, CBL, CBLLE, CLLE, RPGLE, PRTF, DSPF & DDS files. I have question: 1. What are the factors [...]
Answer Question
| August 18, 2012 6:02 AM
AS/400, CL/400, DB2/400, DSPF, ILE, Printer files
Journaling if I drop a table
Hi Tom, New to iSeries. If I drop and recreate a table with two additional fields, will the journalling be cleared out too? Also will the jounalling be enabled when I recreate the table? I have this brief…….. We need to have the old journal entries (relating to the current layout before the changes) [...]
Answer Question
| May 4, 2012 10:35 AM
DB2/400, iSeries AS/400
Hi Tom, New to iSeries. If I drop and recreate a table with two additional fields, will the journalling be cleared out too? Also will the jounalling be enabled when I recreate the table? I have this brief…….. We need to have the old journal entries (relating to the current layout before the changes) [...]
Answer Question
| May 4, 2012 10:35 AM
DB2/400, iSeries AS/400
DB2/400 count physical file record
how to count the physical file records using RPGLE program….
Answer Question
| February 28, 2012 2:52 PM
DB2/400
how to count the physical file records using RPGLE program….
Answer Question
| February 28, 2012 2:52 PM
DB2/400
override database and logical file
what the main difference between OVRDBF override database in CL and logical file… which one have most advantage…
Answer Question
| March 19, 2012 7:09 AM
DB2/400
what the main difference between OVRDBF override database in CL and logical file… which one have most advantage…
Answer Question
| March 19, 2012 7:09 AM
DB2/400
DB2/400 delete record
how to delete record using UPDDTA command…
Answer Question
| February 28, 2012 5:46 AM
DB2/400
how to delete record using UPDDTA command…
Answer Question
| February 28, 2012 5:46 AM
DB2/400
DYNSLT (Dynamic Select Concept)
Hello All, This question is regarding the dynamic selection concept in DB2/400. As we know we can create a LF with our without the DYNSLT keyword. The question is what is the difference in using LF with and without DYNSLT? What should I prefer if my PF handles millions of records? Thanks in advance
Answer Question
| November 16, 2011 9:53 AM
DB2/400
Hello All, This question is regarding the dynamic selection concept in DB2/400. As we know we can create a LF with our without the DYNSLT keyword. The question is what is the difference in using LF with and without DYNSLT? What should I prefer if my PF handles millions of records? Thanks in advance
Answer Question
| November 16, 2011 9:53 AM
DB2/400
Problem converting numeric to date data type
I have a zoned decimal field as s 6 and i am trying to convert it to date format as mmddyy in sql…It giving error ..please help me out ..I tried using date and cast function but its not working !!
Answer Question
| March 19, 2012 11:24 PM
DB2/400, SQL
I have a zoned decimal field as s 6 and i am trying to convert it to date format as mmddyy in sql…It giving error ..please help me out ..I tried using date and cast function but its not working !!
Answer Question
| March 19, 2012 11:24 PM
DB2/400, SQL
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?
Answer Question
| March 31, 2012 9:31 AM
AS/400 DB2, DB2/400, Dropbox, Radio buttons
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 !
Answer Question
| March 31, 2012 2:55 PM
AS/400 DB2, AS/400 to Linux OS, DB2/400, Linux, Linux file system
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. [...]
Answer Question
| March 31, 2012 5:43 AM
AS/400 DB2, AS400 physical file, DB2/400, Physical Files
COBOL/400, DB2/400
Hi Group, I have a Physical file. It has 3 members, memb1, memb2 and memb3. In my cobol/400 program i need to access all the 3 members and put data into them. What is the select statement for the multimember PF? How to declare the file section for multi member PF? The COBOL/40o pgm should [...]
Answer Question
| July 6, 2011 5:35 AM
COBOL/400, DB2/400
Hi Group, I have a Physical file. It has 3 members, memb1, memb2 and memb3. In my cobol/400 program i need to access all the 3 members and put data into them. What is the select statement for the multimember PF? How to declare the file section for multi member PF? The COBOL/40o pgm should [...]
Answer Question
| July 6, 2011 5:35 AM
COBOL/400, DB2/400
Question on Physical Files & Logical Files
Hi Group, I have a Physical file. I created a Logical file on it with a key field as Primary key. Later as per the new requirements i created a LF with composite key as primary key. Should i make any changes to the LF that was created earlier??
Answer Question
| May 18, 2011 8:28 AM
AS/400, AS400 physical file, DB2/400, Logical Files
Hi Group, I have a Physical file. I created a Logical file on it with a key field as Primary key. Later as per the new requirements i created a LF with composite key as primary key. Should i make any changes to the LF that was created earlier??
Answer Question
| May 18, 2011 8:28 AM
AS/400, AS400 physical file, DB2/400, Logical Files
How to use “Program-Described-File” for converting an AS/400 numeric field into Char-field
My situation is….. I have a file which is old & got 18,000 records in it. It has a numeric-field(Amount, Len 9,2). Now the ‘Amount’Field in the file is changed to 12-char, in the new library. only this field’s name is changed in order to avoid ambiguity. Otherwise the file-name & other fields remain the [...]
Answer Question
| December 18, 2010 5:50 PM
AS/400, AS/400 numeric fields, DB2/400, OVRDBF, RPG Program
My situation is….. I have a file which is old & got 18,000 records in it. It has a numeric-field(Amount, Len 9,2). Now the ‘Amount’Field in the file is changed to 12-char, in the new library. only this field’s name is changed in order to avoid ambiguity. Otherwise the file-name & other fields remain the [...]
Answer Question
| December 18, 2010 5:50 PM
AS/400, AS/400 numeric fields, DB2/400, OVRDBF, RPG Program
How to move an AS/400 numeric field to an alphanumeric field without disturbing the value in it?
How to move a numeric field to an alphanumeric field without disturbing the value in it. I have a numeric field(9,2) with value MyVar = 9876543.21 I need to move this (as it is)into an alphanumeric field(12 A), without distorting the value in it. But if I use %CHAR, it gets moved along with decimals, [...]
Answer Question
| December 8, 2010 11:18 AM
AS/400, DB2/400, OS/400, RPG/400
How to move a numeric field to an alphanumeric field without disturbing the value in it. I have a numeric field(9,2) with value MyVar = 9876543.21 I need to move this (as it is)into an alphanumeric field(12 A), without distorting the value in it. But if I use %CHAR, it gets moved along with decimals, [...]
Answer Question
| December 8, 2010 11:18 AM
AS/400, DB2/400, OS/400, RPG/400
AS400 RUNSQLSTM – Problem with CAST
I am using a RUNSQLSTM to insert records from file A into file B. One of the fiels in defined as 4S 0 in file A and as 4A in file B. If the value in file A is zero, not matter what I have tried file B gets populated with a 0 followed by [...]
Answer Question
| November 9, 2010 4:27 PM
AS/400, DB2/400, RUNSQLSTM, SQL Server, V4R5
I am using a RUNSQLSTM to insert records from file A into file B. One of the fiels in defined as 4S 0 in file A and as 4A in file B. If the value in file A is zero, not matter what I have tried file B gets populated with a 0 followed by [...]
Answer Question
| November 9, 2010 4:27 PM
AS/400, DB2/400, RUNSQLSTM, SQL Server, V4R5
