DB2

SQL DB2 COBOL date reformatting

Hi and thanks in advance,I want to use DB2 SQL in COBOL to reformat a date from CCYY-MM-DD to MM-DD-YY. What is the simplest and most efficient way to do this?Christy

View Answer   |  May 6 2008   3:26 PM GMT   |  asked by Ctrevino
COBOL, SQL, DB2

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...

Answer Question   |  Apr 23 2008   4:54 PM GMT   |  asked by Leah Rosin
DB2, Territory Codes

DB2 indexes and Crystal Reports

Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?

Answer Question   |  Apr 22 2008   10:31 AM GMT   |  asked by AJ52
DB2, Indexes, Crystal Reports 8

Data transfer from DB2 (AS400) TO SQL SERVER 2005

I want to transfer a data from a DB2 file to a SQL Server file.I do not want to buy a software that do it.I want to do it by my self (perhaps using ODBC)Thinks all for help.Abdou

View Answer   |  Apr 1 2008   3:03 PM GMT   |  asked by HABDOU
Data transfer, AS/400, DB2

DB2 Web Query- Change Report Layout

I have a report which contains all the information I require. The problem is, there are two totals (automatically produced after a break) that I would like to move down to another section of the report. Any way of doing this?

View Answer   |  Mar 19 2008   6:17 PM GMT   |  asked by TomS
DB2 Web Query, DB2

Tagged text in Windows to be inserted into Db2 Clob column on Mainframe

I have a string-combinatino of rich text and tagged test: ex: "test msg <p><STRONG></P>" on Windows machine. How i can insert data 'AS IS' without any data loss into a Db2 clob column. Db2 is residing on mainframe and we are using Db2 version 8.

Answer Question   |  Mar 14 2008   7:48 AM GMT   |  asked by Narayananv
DB2, CLOB, SQL

DB2 image copy that is no longer in SYSCOPY on zOS operating system

We have a tablespace that needs to be restored from an image copy which we have the problem is the image copy is not recorded in SYSCOPY. We also tried doing a UNLOAD FROMCOPY thinking if we got the data out of the image copy we would be able to load it back into the table. That also failed with...

Answer Question   |  Mar 11 2008   5:27 PM GMT   |  asked by EPPERSON
DB2, SYSCOPY, z/OS

DB2 Load Utility

If I run the DB2 LOAD utility LOG NO REPLACE is all the data externalised to DASD immediatley ? I.e. if I ran DSN1COPY against the underlying VSAM dataset immediately (without stopping pageset) would all rows be copied ?

Answer Question   |  Mar 5 2008   4:59 PM GMT   |  asked by Ian in Uk
DB2, LOAD, DSN1COPY

DB2 to Text File Conversion and Transfer

I have craeted a Text File from my AS400 DB2 table. I want to transfer this file from one iSeries system to another. How to do this??

View Answer   |  Mar 1 2008   2:50 PM GMT   |  asked by Gvdsswami
DB2 Implementation, AS/400 DB2, DB2

Mainframe Career - is it possible for me?

hello,I have been working for a MNC in India for the past 2 years.My nature of Job includes creating SAS programs and using JCL to run this SAS and get reports or other stuff from the DB2 databases or files.I also write simple SQL queries for DB2.I am right now in a stage where i need to decide...

Answer Question   |  Feb 29 2008   5:51 AM GMT   |  asked by Richard1983
Mainframe, SAS, DB2

OLE DB using Library List

Hi,Do any one use OLE DB to connect to iSeries?Is OLE DB capable of using Library List provided by Job Description?Because when I used it, I have to specify the library name / schema and object name.Please advice...Thank you

View Answer   |  Feb 20 2008   11:49 PM GMT   |  asked by TG
AS/400, DB2, DB2 universal database

Can Siebel run on AS/400 / iseries and connect to DB2/400?

Can Siebel run on AS/400/iseries and connect to DB2/400? If not what are the best options to deploy it on AS/400?

View Answer   |  Feb 20 2008   10:47 PM GMT   |  asked by Uiiuo
Siebel, AS/400, DB2

Download from the AS400 tab delimited file

I need to be able to download in an automated fashion, a DB2 table as a tab delimited text file on a PC. I have successfully done this manually using the Actions munu in client access but need to be able to do it automatically in either a CL of a PC scheduled job so that it will run unattended.Any...

View Answer   |  Feb 12 2008   4:13 PM GMT   |  asked by Butcheanes
CL, DB2, AS/400

How to calculate logical file size

Hi,I need to be able to estimate the size of a logical file (inc access path). I've tried creating this file and almost filled the machine up. This is logical has quite a lot of key fields.Does anyone know a simple way of estimating the size (IBM has a formula in the manuals, but I can't make out...

Answer Question   |  Feb 8 2008   10:36 AM GMT   |  asked by Gilly400
AS/400, DB2, File

left outer join in trigger DB2 Z/OS

I'm having problems writing a trigger that contains a left outer join. Here is the trigger: CREATE TRIGGER H000.H0TRCAD2 AFTER DELETE ON H000.H0COO_TRANS_CALLC REFERENCING OLD AS OLD_ROW FOR EACH ROW MODE DB2SQL BEGIN ATOMIC SELECT OLD_ROW.CLNT_ID , OLD_ROW.ACCT_NBR , OLD_ROW.PST_DT ,...

Answer Question   |  Feb 7 2008   3:34 PM GMT   |  asked by X00005
DB2, z/OS, Trigger

Table partitioning, CLOB and BLOBs in DB2 9 LUW?

Hi all,My shop has decided that we will take advantage of DB29 table partitioning for some of our large tables. Some of these table have CLOB, LOB and BLOB columns. We intend to split the large tables across several storage objects. I am looking for someone who have done table partitioning and...

Answer Question   |  Jan 31 2008   8:48 PM GMT   |  asked by OKONITA
Table partitioning, DB2, BLOB

Lotus Notes and AS400 (DB2)

I have a form in Notes where a user enters a reference number. When the user clicks the submit button I want to Validate their reference number against a table on our AS400. I am able to do this with an ODBC connection on my workstation but... MANAGEMNT does not want users to have any type of...

View Answer   |  Jan 22 2008   5:55 PM GMT   |  asked by Shooby
Lotus Domino, Lotus Notes, DB2

File sort using qshell (this time with tags)

Hi,I'm trying to use qshell to do a sort of a (non-keyed) DB2 database file to remove duplicate records. I use the following command :-sort -u /QSYS.LIB/$1.LIB/$2.FILE/$3.MBR | cat > /QSYS.LIB/$1.LIB/$2.FILE/$3.MBRWhere $1 = Library name, $2 = File name, $3 = Member name.The command does a sort,...

Answer Question   |  Jan 16 2008   3:12 PM GMT   |  asked by Gilly400
AS/400, Unix shells, Qshell

How to use PL/I command LIKE with DB2

I wont to use PL/I comman like for using same structure twice. Compiler returns error : IBM7043I S 4.1 SQL0314N The host variable "xxxxxxxx" is incorrectly declared. SQLSTATE=00000IBM7043I S 9.1 SQL0117N The number of values assigned is not the ...

Answer Question   |  Jan 16 2008   2:57 PM GMT   |  asked by Sccsofti
PL/I, DB2, iSeries programming commands

oracle calculated item

hi ihave alist of variables some of them calculated from others i recieved them from certain source in certain date and i have alist of indicatores which are calculated from the variables (for the same date,& source) but every indicator has diffrent equation & the user need to modify the equation f...

View Answer   |  Jan 13 2008   1:12 PM GMT   |  asked by Rosealzubi
DB2, USE DATABASE, Database Management Systems