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
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
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
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
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’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
How can I execute 10 sql at one go ?
Answer Question | October 14, 2008 6:54 AM
DB2, QMF, Query Management Facility, SQL
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 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
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
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 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
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
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
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’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
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
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
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
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