• Territory code in UDB DB2 database

    A reader wrote in with this question: <i>Can you explain the meaning of the territory code when creating a db2 udb database? Certain documentation say that the territory code determines the way dates are displayed but I've experimented by creating several databases with different territory...

    Leah Rosin575 pointsBadges:
  • Is it possible convert a mainframe COBOL program to read DB2 data on the mainframe and Oracle data on a server?

    I have a mainframe batch COBOL program that reads DB2 data. One of the tables is accessed via a singleton SELECT. The table is being moved to an Oracle database on a Unix server. How do I change the program to be able to access the data in Oracle? Are there different ways to it? I'm assuming there...

    Srichfdic20 pointsBadges:
  • 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 can code...

    SUZB5 pointsBadges:
  • SQL query error: token DATA

    I am new to Db2 on iSeries. I am running some SQL script files using JDBC to create a repository on DB2 for my project. The query is of the form: Create table tbl_name(col1 datatype(size),...... ,coln datatype(size)) DATA CAPTURE NONE; I am getting error on token DATA.. I tried to execute this...

    AS400 - Ask the Expert485 pointsBadges:
  • QMF

    can we save the statements write in QMF?

    Avijji5 pointsBadges:
  • How to limit the number of application connections in DB2?

    I want to limit the number of application connections to 1 in DB2 server. And try connecting with 2 applications to check the behavior?

    Saimadhu455 pointsBadges:
  • Office 2007

    I have QMF for Windows 7.2 installed on my computer. I just got Office 2007 installed on my computer. Now, the Excel QMF Add-on is not working properly. I have a query with eight columns. when I use the QMF add-on to retrieve the data, it only retrieves 3 of the columns. How can I get the add-on to...

    AuntDi5 pointsBadges:
  • Find the DB2 Contoken

    I have the load modules, can I look at them and find the DB2 CONTOKEN to match the package contoken?

    BhleftD10 pointsBadges:
  • 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.

    Dhanson20 pointsBadges:
  • 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 records I want to select for...

    Michaelf215 pointsBadges:
  • 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...

    AlanJ5 pointsBadges:
  • mainframe db2 – get current month and year

    Please advise. My DB2 statement does not work. gl_date is a date field, format is 'yyyy-mm-dd'. select * from db2 table where year(gl_date) = year(current date) and month(gl_date) = month(current date);

    Rulala5 pointsBadges:
  • AS400 – DB2 file names

    Given a view name, how will i find its physical file name... e.g. my view name is EMP_TMP_TPL_HDR Thanks, NG

    Nutangujar895 pointsBadges:
  • As400 – XML

    Can i pass value from DB2 400 to XML.. how to do this?

    Nutangujar895 pointsBadges:
  • IDelete QPFRDATA

    Hi, I just want to ask if it is possible to delete the PF (Physical File) inside my performance data library without causing any problem on my AS400 system. I found out that its file is so big.  

    c007285 pointsBadges:
  • DB2

    i have display file which inputs a varibale say Var1.... This is updated in a PF. My problem is program is not updating this varibale in this file. it updates all other varibales...i checked the library list and evrythng is in place... in PF, the field name is Var1. i use the same name for DSPF -...

    Nutangujar895 pointsBadges:
  • GET OPID SEGMENT CICS FROM A COBOL/DB2/CICS PROGRAM (RACF)

    Please I need Get the OPID segment CICS  of RACF from a COBOL/CICS  Program.   Thanks JORGE

    RACF5 pointsBadges:
  • AS400 – DB2 concepts

    In AS400, suppose I have 4 files to update and system encounters failure while updating 4th file.....I such scenario will the transactions on first 3 files will rollback.... how can i write a sample program to test this... i want to understand how 'Transaction' is defined in this scenario... Is it...

    Nutangujar895 pointsBadges:
  • Access & iSeries AS400 Tbl and Query Issues Error Code 5001

    I am in Access and I have (A) a passthrough queries=(INMSP300) and (B) table queries=(dbo_ECC_APP.OEM),I want to join. In the dbo_ECC_APP.OEM there are number identifiers that have no associate number were in INMSP300 there are both and they are associated. So I need to have all the number in the...

    CompEng1,185 pointsBadges:
  • IBMDB2 runtime issues with HP 2730p laptop

    When displaying catalogue with IBM DB2 Runtime, a blank display appears.  It will not display the command windowl  This problem occurs only with the HP 2730p Tablet.

    Jmonroe700ing10 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following