As previously posted, the IBM Software Newsgroup server (news.software.ibm.com) will close by the end of the year. In preparation for the shutdown,...

Alexei Gabler

12-02-2009 05:10 AM
Alexei Gabler

Hi, I'm fairly new to writing queries in DB2 and am having some issues with dates, I have an 8 digit field on a file in which a date is stored in...

11-25-2009 11:04 PM
P.Dow

In WDSC v6 there is an RDB to XML mapping editor. I can't find it in WDSC v7 or in RDi. Was this editor moved into another product? And if so,...

phil.g

11-23-2009 12:18 PM
phil.g

I was able to extract DDL using iSeries Navigator as mentioned in the redbook found @ http://www.redbooks.ibm.com/abstracts/sg244249.html chapter 9...

rggnanaraj

11-19-2009 10:19 AM
rggnanaraj

I work predominatly on DB2 (LUW). However, now I need to extract the DDL of a DB2 database on iSeries. In DB2 (LUW), we normally use db2look...

rggnanaraj

11-19-2009 10:04 AM
rggnanaraj

After some more investigation I have found the problem has something to do with the MS distributed transaction coordinator. If I stop the MSDTC on...

mwagoner@wildflavors.com

11-18-2009 02:06 PM
daspeac

This Newsgroup will close by the end of the year. IBM invites participants of this Newsgroup to join the IBM developerWorks forum...

Alexei Gabler

11-18-2009 11:41 AM
Alexei Gabler

DB2 for i follows the version of the IBM i. DB2 for other platforms follows a separate versioning number. How do you determine what version of DB2...

JimBerl

11-11-2009 01:32 PM
DaveSlash

Hi, i connect my i5 from c# .net using the ibm-managed provider shipped with my client access. All my customers have client access with enough...

jogis

11-10-2009 08:53 AM
HenkW

Hi I am trying to restore a db2 schema to another schema on the same system. Basically we want to replicate a collection for testing purpose. But I...

Mike148

11-05-2009 09:52 AM
Kent Milligan

I'm using linked server in SQL Server to get data from our DB2 database that resides on our iSeries server. When I do a select into SQL Server...

BDT

10-28-2009 08:51 AM
ldubois

Hi, While connecting to db2 from WAS, following error occurs in admin console. The test connection operation failed for data source Agcy Dwld DS...

itzprema@gmail.com

09-28-2009 03:10 AM
itzprema@gmail.com

Hi Experts, We have an issue with db2 in iseries as we are not able to get date before 1940.We are getting the value as NULL but still the data is...

R.K.Nair

09-25-2009 11:53 AM
Stephen385

I'm new to using the iSeries .NET provider and I'm looking for a suggestion on how best to use it. I using a DataGridView control and I specify its...

Stephen385

09-25-2009 11:44 AM
Stephen385

I have added the registry values like IBM tech document 526181697 says but I still do not see it listed. The IBM .NET provider is in the directory...

Stephen385

09-25-2009 11:07 AM
Stephen385

When i try connecting to db2 database from the administrative console of WAS, i get the following error: The test connection operation failed for...

itzprema@gmail.com

09-25-2009 10:23 AM
HenkW

I have one table on AS400 DB2 database something like with three columns... *FirstName LastName Department* James Anderson ...

superdec@gmail.com

09-25-2009 09:57 AM
Kent Milligan

Hi all, i'm running a C# program that reads a file on iSeries via IBM UDB .Net provider. It seems to work very well, but somtimes i receive an...

09-22-2009 11:38 AM
ldubois

could someone provide an example of how to select the Permissions for the components within an iSeries database. for all the tables, procedures,...

raleigh

09-15-2009 10:56 AM
Kent Milligan

I am writing a report and am using IBM's DB2 to create my stored procedure. In the report's selection criteria I want to allow the user to select...

shaycullen@dunbia.com

09-11-2009 01:42 PM
Kent Milligan

We have developed a J2EE, JBOSS application (on Linux O/S) with DB2 as backend database. As customer wanted a failover of database in real time and...

goodbazaar@yahoo.com

09-11-2009 01:41 PM
Kent Milligan

Hi Friends, I've created SQL stored procedures in our development schema and its working fine. Now we are in the task of moving our development codes...

csuresh@itsoln.com

09-04-2009 01:38 AM
giovanni_figari@it.ibm.com

When SQL server mode is established, all SQL statements are passed to an independent server job that will handle the requests. Server mode behavior...

unforgettable@vipmail.hu

09-03-2009 08:04 PM
Tom Liotta

When using the SSIS wizard and selecting the OLE DB data provider IBMDA400 I can set the iSeries, user and password and get the table BUT. I get the...

09-02-2009 05:15 PM
sgorovoy@marcalpaper.com

Hi I am running a stored procedure that contains a set of UPDATE statements on the SQL / 400 and it runs fine. When I invoke the same procedure...

TiredOfDB2

09-01-2009 04:22 PM
CRPence

Hi.. in iSeries sql table we can create a column with an identity property, and database automatically increments this column value with each...

em

08-31-2009 08:24 PM
CRPence

Hello everyone I would like you to help me, I have the following situation: I have DB2 V6R1 and I have configure QDECFMT with option 1 = blanks, but...

robert_babe76@hotmail.com

08-29-2009 11:44 AM
B.Hauser

=(year(fromdate)-1900)*1000+ dayofyear(fromdate) and shippingdate =fromcode AND laststatus =fromcode and t1.sdlttr...

TiredOfDB2

08-28-2009 08:20 AM
unforgettable@vipmail.hu

Hello I need to agregate in a SQL select text fields by a common ID in a calculated text field, something like SUM but with CHAR fields. For example...

mdb

08-25-2009 12:04 PM
Kaj Julius

Hi, i have huge problems to create a ODBC in Windows 2008x64 with V5R3M0 Any suggestions?

john.andersson@greencargo.com

08-20-2009 06:45 AM
bryan dietz

Recently, we encountered lots of row locks after creating a *composite index* on one table. After dropping the index, everything is OK, now. The...

andrewwang1@yahoo.com

07-30-2009 01:36 PM
CRPence

Kent Milligan wrote: Kent, the example given was for an SQL CALL, not a CL CALL. What Jhon had attempted, was to issue the SQL CALL from the DB2...

CRPence

07-16-2009 09:34 AM
Kent Milligan

I am starting a new thread on this topic instead of continuing to piggy-back off of another post. The issue here is using multiple parameters in a...

farconserv@sherbtel.net

07-14-2009 01:39 PM
cho@mother-parkers.com

Hello I need to call a java stored procedure from a SQL trigger and i.e. at update to know the old and new values that are available at SQL side in...

martin@decoexsa.com

07-06-2009 12:06 PM
martin@decoexsa.com

Hi All First post on this forum hopefully someone can help me out. I am currently trying to write sql stored procedures for db2 i5/OS. Can anyone...

mmontgomery@dunbia.com

07-06-2009 08:25 AM
mmontgomery@dunbia.com

Hi All, I want to excecute AS400's CL command using Java Sql Statement. I can do it using JT400's ProgramCall/CommandCall but it creates an...

ahmad22.saif@gmail.com

06-18-2009 09:43 AM
CRPence

testconn20.exe database=S655fe4d ;server=10.0.0.99:446;userid=webquery;password=kwebquery Step 1: Printing version info .NET Framework version:...

maltra@tin.it

06-10-2009 05:40 AM
maltra@tin.it

Hi, I have exported my database successfully from db2 express c. Now I have to shift all the files to iSeries and import them on the created tables...

zhassan@pakre.org.pk

06-03-2009 03:08 PM
HenkW

Hi I am trying to execute a ddl which I made from db2look utility in db2 Express C for windows in Power 6 (iSeries). However on the text type clobs...

zhassan@pakre.org.pk

06-03-2009 03:01 PM
HenkW

Does anyone have any thoughts on the following problem. I run the following SQL on a table (output from QAUDJRN model file) with approximately 16...

glynn.jones@chilli-it.co.uk

05-21-2009 07:09 AM
HenkW

I am writing an RPG program using the SQL CLI API's. When I execute my query the return code is -1 and message SQL0204 is sent with text 'ITMST in...

lburkett99@embarqmail.com

05-14-2009 11:14 AM
B.Hauser

We try to convert the DDS defined physical files to DDL defined SQL tables. Most our application program are written with RPG using native API to...

05-11-2009 01:43 PM
CRPence

Dear all, if there someone, who successfully install MySQL v5.1.34 on IBM. Power System V5.4? Because i already successfully installed MySQL (i...

choky@binareka.co.id

05-08-2009 02:20 AM
HenkW

I have a library that only contains sql stored procedures. On the first call some of them take anywhere from 20 - 40 seconds to return. Subsequent...

paul@pcssinc.com

04-23-2009 07:19 AM
mwagoner@wildflavors.com

restore, so we wondering is it possible to connect from COBOL application on AS400(boughten in 2004) to Windows DB2 v9.5 without any problems(i.e....

allacces@lortemail.dk

04-21-2009 11:43 AM
Kent Milligan

How many databases can you create on a partition? Local or otherwise? It appears that there can only be one, but I am looking for some verification...

farconserv@sherbtel.net

04-21-2009 11:41 AM
Kent Milligan

I have created some SQL Stored Procedures in a DB2 environment running on i5OS V5R4. I am nesting them to be able to perform a load of an ODS. The...

farconserv@sherbtel.net

04-16-2009 07:18 AM
mwagoner@wildflavors.com

I need to insert around 30 fields at a time into one table(file) from outside the iSeries. Would a Stored procedure with 30 parameters be feasible...

bsmills@magellanhealth.com

04-10-2009 01:31 PM
farconserv@sherbtel.net

are there VisualStudio Addins available from IBM for developers who are NOT using the DB2 UDB .Net provider and DB2 Connect? in other words, we are...

raleigh5@hotmail.com

03-27-2009 02:58 PM
bwigfield@favoritestaffing.com

Not sure if I'm posting this in the wrong place, but it pertains to Db2. I've also posted my question in the Zend developer zone forums, but nobody...

pgrimard@gmail.com

03-12-2009 03:45 PM
ddressler@legalplans.com