FORMAT keyword in non-join logical files — what and how?
How do I use FORMAT keyword in a non-join logical file? What is the main purpose of that keyword?
Answer Question
| November 4, 2008 5:46 PM
DB2, FORMAT keyword, Logical File
How do I use FORMAT keyword in a non-join logical file? What is the main purpose of that keyword?
Answer Question
| November 4, 2008 5:46 PM
DB2, FORMAT keyword, Logical File
Prevent Update in DB2 SQL External Trigger Program
I have a 3rd party application that maintains a customer master file (update, insert, delete) and I cannot alter their programs. I would like to put a trigger on the database file to fire an external program on insert and determine if the insert should be performed. If not, I would like to send a [...]
Answer Question
| November 6, 2008 4:29 PM
AS/400, DB2, SQL, Triggers
I have a 3rd party application that maintains a customer master file (update, insert, delete) and I cannot alter their programs. I would like to put a trigger on the database file to fire an external program on insert and determine if the insert should be performed. If not, I would like to send a [...]
Answer Question
| November 6, 2008 4:29 PM
AS/400, DB2, SQL, Triggers
DB2/400
Hello Guys, In DB2/400 even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value “Y” or “N”. How to see this indicator field? How to see the DB2/400 RRN (Relative record number)field? I tried with RUNQRY command, [...]
Answer Question
| July 22, 2009 11:37 AM
DB2, DB2/400, DB2/400 RRN, Relative Record Number, Reorganize Physical File Member, RGZPFM, RRN, RUNQRY
Hello Guys, In DB2/400 even after we delete record from file, the record exists until we are done with RGZPFM. The deleted record can be identified by a indication field with value “Y” or “N”. How to see this indicator field? How to see the DB2/400 RRN (Relative record number)field? I tried with RUNQRY command, [...]
Answer Question
| July 22, 2009 11:37 AM
DB2, DB2/400, DB2/400 RRN, Relative Record Number, Reorganize Physical File Member, RGZPFM, RRN, RUNQRY
Data Extract
What is the easiest way to extract data from a pipe-delimited text file?
Answer Question
| September 13, 2010 2:37 PM
CL, DB2, Pipe-Delimited Text File, RPG
What is the easiest way to extract data from a pipe-delimited text file?
Answer Question
| September 13, 2010 2:37 PM
CL, DB2, Pipe-Delimited Text File, RPG
EDM Pool Usage
I have a Cobol program which calls another DB2 program which in return executes a procedure. And this call happens more than thousands time…so EDM Pool getting filled up with pages which shuts down the DB2. Can you suggest what needs to be done to minimize the EDM Pool issue.
Answer Question
| August 5, 2009 4:53 PM
COBOL, DB2, EDM Pool
I have a Cobol program which calls another DB2 program which in return executes a procedure. And this call happens more than thousands time…so EDM Pool getting filled up with pages which shuts down the DB2. Can you suggest what needs to be done to minimize the EDM Pool issue.
Answer Question
| August 5, 2009 4:53 PM
COBOL, DB2, EDM Pool
Extracting data from a DB2 table using IKJEFT01
I’m trying to extract data from a DB2 table via an SQL query and use IKJEFT01 to create a flat file. However, one of the non-key fields contains characters that are not nulls but non-printable. Whenever IKJEFT01 extracts these characters it changes them to nulls in the flat file. Is there an alternative IBM utility [...]
Answer Question
| September 22, 2009 12:30 PM
DB2, DB2 Table, IKJEFT01, SQL Query
I’m trying to extract data from a DB2 table via an SQL query and use IKJEFT01 to create a flat file. However, one of the non-key fields contains characters that are not nulls but non-printable. Whenever IKJEFT01 extracts these characters it changes them to nulls in the flat file. Is there an alternative IBM utility [...]
Answer Question
| September 22, 2009 12:30 PM
DB2, DB2 Table, IKJEFT01, SQL Query
QMF for Windows
How can I execute 10 sql at one go ?
Answer Question
| October 14, 2008 6:54 AM
DB2, QMF, Query Management Facility, SQL
How can I execute 10 sql at one go ?
Answer Question
| October 14, 2008 6:54 AM
DB2, QMF, Query Management Facility, SQL
DB2 Web Query
Hello Does anyone know how to select fields in the DB2 Query for report purposes, and yet not have them appear in the sort by window pane. Seem simple enough, but, when I have the field select tab highlighted, and double clik on any field, the field automatically appears in the sort by window pane. [...]
Answer Question
| October 20, 2008 9:28 PM
DB2, DB2 Web Query
Hello Does anyone know how to select fields in the DB2 Query for report purposes, and yet not have them appear in the sort by window pane. Seem simple enough, but, when I have the field select tab highlighted, and double clik on any field, the field automatically appears in the sort by window pane. [...]
Answer Question
| October 20, 2008 9:28 PM
DB2, DB2 Web Query
DB2 Web Query
Hello I created metadata over a a “set” of files. My next step is to define a primary over one of the files, and then foreign keys over the other files defined in my metadata relational database. Unfortunately, when I attempt to define my primary key over the main file, I receive an SQL error [...]
Answer Question
| October 13, 2008 8:30 PM
DB2, DB2 Web Query, Metadata
Hello I created metadata over a a “set” of files. My next step is to define a primary over one of the files, and then foreign keys over the other files defined in my metadata relational database. Unfortunately, when I attempt to define my primary key over the main file, I receive an SQL error [...]
Answer Question
| October 13, 2008 8:30 PM
DB2, DB2 Web Query, Metadata
Field editing for DB2 WebQuery
How can I provide field editing for DB2 WebQuery? For example: phone number(length 10, decimals 0) as (123)456-7890 and Customer Id# (length 6, decimals 0) as 1234-56 . DB2 WebQuery doesn’t seem to pay attention to the edit words/edit codes of the PF DDS, so I am trying to do my own “editing”. I want [...]
Answer Question
| October 3, 2008 5:54 PM
AS/400, DB2, DB2 Web Query
How can I provide field editing for DB2 WebQuery? For example: phone number(length 10, decimals 0) as (123)456-7890 and Customer Id# (length 6, decimals 0) as 1234-56 . DB2 WebQuery doesn’t seem to pay attention to the edit words/edit codes of the PF DDS, so I am trying to do my own “editing”. I want [...]
Answer Question
| October 3, 2008 5:54 PM
AS/400, DB2, DB2 Web Query
SAP 4.6c migration from MS SQL 2000 to IBM iOS DB2 database
Hi I need to investigate the work load required to migrate SAP4.6C HR from a MS SQL2000 database to a Integrated DB2 IBM i OS Database? Is there tools available for this ? any information will be beneficial Thanx from a system i techie that know nothing about SAP!lol
Answer Question
| September 30, 2008 10:29 AM
DB2, IBM i, SAP development, SAP HR, SAP migration, SQL Server 2000
Hi I need to investigate the work load required to migrate SAP4.6C HR from a MS SQL2000 database to a Integrated DB2 IBM i OS Database? Is there tools available for this ? any information will be beneficial Thanx from a system i techie that know nothing about SAP!lol
Answer Question
| September 30, 2008 10:29 AM
DB2, IBM i, SAP development, SAP HR, SAP migration, SQL Server 2000
How can i connect DB and input values in stored procedures using VBA
hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me….
Answer Question
| September 23, 2008 6:41 AM
DB2, Stored Procedures, VBA
hi all, i am using a automation tool, which is with VBA scripting. I want to execute the stored procedure by giving the values. guys help me….
Answer Question
| September 23, 2008 6:41 AM
DB2, Stored Procedures, VBA
Create a view in DB2/400
I need an example to create a view in DB2/400. I Need to create a view where the table name is greather than 8 characters and collumns names greather than 6 characters. please somebody can help me??
Answer Question
| July 31, 2010 3:09 PM
DB2, DB2/400
I need an example to create a view in DB2/400. I Need to create a view where the table name is greather than 8 characters and collumns names greather than 6 characters. please somebody can help me??
Answer Question
| July 31, 2010 3:09 PM
DB2, DB2/400
export to csv file from java app
In windows our java application calls one .bat file which runs db2 export command to export data to csv file,how can i do the same on iseries…i dont have any knowledge of iseries and we need to deploy our application on iseries …can anyone tell me how to do the same thing on iseries
Answer Question
| September 9, 2008 3:01 PM
AS/400, CSV, DB2, Java applications
In windows our java application calls one .bat file which runs db2 export command to export data to csv file,how can i do the same on iseries…i dont have any knowledge of iseries and we need to deploy our application on iseries …can anyone tell me how to do the same thing on iseries
Answer Question
| September 9, 2008 3:01 PM
AS/400, CSV, DB2, Java applications
Export in db2 iseries
i want to export query output to a csv file on iseries ..can anyone tell me how to do that
Answer Question
| September 9, 2008 12:23 PM
CSV, DB2, iSeries
i want to export query output to a csv file on iseries ..can anyone tell me how to do that
Answer Question
| September 9, 2008 12:23 PM
CSV, DB2, iSeries
DB2 WebQuery: Metadata Error FOC1567
I’m new to DB2 Web Query. Just starting with the product. In metadata, I’m trying to pull in a DB2 SQL derived Table. I keep getting an error FOC1567. *LOCAL, <create synonym>, Table <only>, library / filename Error FOC1567 Create Synonym Data Source ‘StockKeepingUnit’ is not unique The KEY on the StockKkeepingUnit Table is a [...]
Answer Question
| March 19, 2010 9:02 PM
DB2, DB2 Web Query, FOC1567
I’m new to DB2 Web Query. Just starting with the product. In metadata, I’m trying to pull in a DB2 SQL derived Table. I keep getting an error FOC1567. *LOCAL, <create synonym>, Table <only>, library / filename Error FOC1567 Create Synonym Data Source ‘StockKeepingUnit’ is not unique The KEY on the StockKkeepingUnit Table is a [...]
Answer Question
| March 19, 2010 9:02 PM
DB2, DB2 Web Query, FOC1567
db2 os/390 v8 utility unload template parms
Hi, We are switching to use the unload utility from the unload program (dsntiaul). I would like to know how to use the template feature to allow multiple volumes to be used in the output. Since we use SMS to manage our storage devices and we want the output on dasd not tape, we normally [...]
Answer Question
| September 23, 2009 3:56 PM
DB2, DB2 8.x, DSNTIAUL, OS/390
Hi, We are switching to use the unload utility from the unload program (dsntiaul). I would like to know how to use the template feature to allow multiple volumes to be used in the output. Since we use SMS to manage our storage devices and we want the output on dasd not tape, we normally [...]
Answer Question
| September 23, 2009 3:56 PM
DB2, DB2 8.x, DSNTIAUL, OS/390
DB2 Select on a large number of rows/
I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the [...]
Answer Question
| September 22, 2009 3:52 PM
DB2, JCL, SQL
I have to run a DB2 against a number of table for example tableA, tableB and select a number of fields from the table. However, I have to run the selection against 5,000 records that. I want to know if using SQL embedded in a JCL, if I could plug in a file with the [...]
Answer Question
| September 22, 2009 3:52 PM
DB2, JCL, SQL
DB2 Spufi output formatted
How do I get 2 lines of user specified headings using db2 SPUFI: SELECT A AS “LINE1 HDG” “LINE2 HDG” FROM TABLE doesn’t work.
Answer Question
| September 22, 2009 9:32 PM
DB2, SPUFI
How do I get 2 lines of user specified headings using db2 SPUFI: SELECT A AS “LINE1 HDG” “LINE2 HDG” FROM TABLE doesn’t work.
Answer Question
| September 22, 2009 9:32 PM
DB2, SPUFI
Find the DB2 Contoken
I have the load modules, can I look at them and find the DB2 CONTOKEN to match the package contoken?
Answer Question
| September 22, 2009 6:40 PM
Contoken, DB2
I have the load modules, can I look at them and find the DB2 CONTOKEN to match the package contoken?
Answer Question
| September 22, 2009 6:40 PM
Contoken, DB2
