how can we take a db2 backup tape and dump to a sql server 2005 database?
Answer Question | April 23, 2010 4:47 PM
AS/400 DB2, DB2, SQL Server 2005
I am using MS excel 2007 and would like to upload data into DB2 database. I could do this before on my older version of excel. How do I do this with MS excel 2007?
Answer Question | May 21, 2008 11:25 AM
DB2, Microsoft Excel
Hi, I am studing databases in a iSeries. All my objects are in librarie called DB1_T2. I need to give access to the professor so he can read all my data and execute my functions. How can I do that via the command line. Thanks a lot.
Answer Question | May 21, 2008 6:46 AM
AS/400 DB2, DB2, iSeries database
Hi, We have DB2 version 8, os/390. I know how to use QMF and JCL. I would like to unload, to files, specific records that I would enter, by the key, in a where clause. The record would then cascade down to unload ALL tables, with a specified TBCREATOR name based on foreign keys. I [...]
Answer Question | June 25, 2008 6:33 PM
DB2, DB2 administration, JCL, OS/390, QMF, Query Management Facility
Hi, I am using C#.Net with DB2 batabase. I have installed IBM .Net Data Provider. I am facing problem with Transaction. when I execute insert query with transaction it doesn’t work and without Transaction it works fine. does anybody know what’s the problem am i making? remember i am using iDb2Transaction which comes with IBM [...]
Answer Question | May 31, 2008 1:12 PM
.NET, .NET Data Provider, C#, DB2
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
Answer Question | July 17, 2008 3:26 PM
COBOL, DB2, SQL
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 codes but I don’t see any difference when using these [...]
Answer Question | September 23, 2009 4:54 PM
DB2, Territory Codes
Is it possible to access DB2 (V5R1) indexes from the Visual Linking Expert screen in Crystal Reports(8) and if so how?
Answer Question | September 23, 2009 10:31 AM
AS/400 DB2, Crystal Reports, Crystal Reports 8, DB2, Indexes, V5R1
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
Answer Question | November 28, 2011 3:03 PM
AS/400, AS/400 DB2, Data transfer, DB2, ODBC, SQL Server 2005
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?
Answer Question | April 2, 2008 6:17 PM
DB2, DB2 Web Query
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 | March 14, 2008 7:48 AM
CLOB, DB2, SQL
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 [...]
Answer Question | May 3, 2010 5:27 PM
DB2, SYSCOPY, z/OS
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 | December 7, 2009 4:59 PM
DB2, DSN1COPY, LOAD
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??
Answer Question | March 3, 2008 2:50 PM
AS/400 DB2, DB2, DB2 Implementation, iSeries database
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 [...]
Answer Question | July 31, 2008 5:51 AM
CICS, COBOL, DB2, Developer, Mainframe, Mainframe jobs, SAS, VSAM.MVS
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
Answer Question | March 12, 2010 11:49 PM
AS/400, DB2, DB2 Universal Database
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?
Answer Question | May 10, 2011 10:47 PM
AS/400, DB2, Siebel
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 [...]
Answer Question | February 13, 2008 4:13 PM
AS/400, CL, DB2
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, [...]
Answer Question | March 14, 2010 10:36 AM
AS/400, DB2, File, Logical File
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 , OLD_ROW.ITM_SEQ_NBR , OLD_ROW.CREAT_TS , OLD_ROW.ALLC_SEQ_NBR , OLD_ROW.ACCTG_CDE , OLD_ROW.ALLC_AMT , OLD_ROW.CREAT_USR_ID , OLD_ROW.UPDT_USR_ID , [...]
Answer Question | July 21, 2008 3:34 PM
DB2, LEFT OUTER JOIN statement, Triggers, z/OS