Hi John,
You can not use the NEXTVAL function directly to access the DB2 Sequence, but you can use the transform KeyMgt.
You can refer this post for more details
[url]viewtopic.php?t=84670&highlight=DB2+SEQUENCE[/url]
-NB
Search found 47 matches
- Tue Aug 29, 2006 1:54 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DB2 NEXTVAL
- Replies: 3
- Views: 2691
- Tue Aug 29, 2006 12:49 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: odbc dsn in pervasive sql
- Replies: 1
- Views: 866
Re: odbc dsn in pervasive sql
Hi, If you want to access an ODBC database from DataStage follow the steps below, 1. install ODBC drivers for the ODBC data source on the DataStage server (MUST).Note: Do not use trial versions of ODBC drivers. 2. Add the path of the directory containing the driver DLL to the Path system environment...
- Tue Aug 29, 2006 11:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: AS/400 connection error
- Replies: 1
- Views: 1515
Re: AS/400 connection error
Hi,
Check this fix.
[url]http://www-912.ibm.com/a_dir/as4ptf.nsf ... enDocument[/url]
I am not sure, this may be the cause. I hope its not because of DS Server
-NB
Check this fix.
[url]http://www-912.ibm.com/a_dir/as4ptf.nsf ... enDocument[/url]
I am not sure, this may be the cause. I hope its not because of DS Server
-NB
- Tue Aug 29, 2006 8:44 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Datastage Buildop
- Replies: 2
- Views: 1397
- Sat Aug 26, 2006 9:56 am
- Forum: Site/Forum
- Topic: Some suggestion/changes for the forum...
- Replies: 6
- Views: 5043
Some suggestion/changes for the forum...
Hi, After noticing the duplicate post (a issue posted by same person/team with different heading), misleading topics or any other issue related with forum usage. It seems this is happening with mostly new users/participants who wish post and get some help/suggestion for their issue. To avoid this, t...
- Fri Aug 25, 2006 5:43 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Half of sequence stages missing from Designer palette
- Replies: 11
- Views: 4701
Hi, This is happened to me, I wondered where my stages are gone :( . Then I found that a dropdown with 0 on it on the Pallete. when I clicked on that all the stages are listed :) . I dragged the stages from the list to the pallete to make them visible out. This may not be same case for you. I just w...
- Fri Aug 25, 2006 5:34 pm
- Forum: General
- Topic: Please read before posting: Appropriate use of this forum
- Replies: 10
- Views: 49880
Hi All ! There lot posts are duplicates opened by the same guy or different user name from the same team. I request everyone using this forum, Please DO NOT try to post duplicate for the same issue, rather I suggest you guys provide good amount of detail about the issue you are facing so that any wi...
- Fri Aug 25, 2006 1:39 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: hi
- Replies: 6
- Views: 2857
- Fri Aug 25, 2006 1:19 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: nvarchar and ntext
- Replies: 3
- Views: 2741
Re: nvarchar and ntext
There is one way to do this, we did everything in SQL server side using "Stuff" function. Using this function you can strip out the unwanted charaters like all the RTF formatting crap. Then load the converted data. Alternatively you can try NCHAR and NVARCHAR2. These are used to store fixe...
- Fri Aug 25, 2006 12:50 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date transformation
- Replies: 3
- Views: 1633
Hi, Please be specific.. Its all depends on which source and target you are using (Oracle, SQLServer, Flat file.....) and what format you required as output and what is input format. Search in this forum you will get lot Date related post that will calrify your doubts. -NB I have never in my life le...
- Fri Aug 25, 2006 9:57 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: xml input stage
- Replies: 10
- Views: 3709
- Fri Aug 25, 2006 9:54 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: xml document importing in datastage
- Replies: 2
- Views: 1600
Re: xml document importing in datastage
Guys !
This is a duplicate post. Please do not answer here.
Use the following post to answer.
viewtopic.php?t=103103
-NB
This is a duplicate post. Please do not answer here.
Use the following post to answer.
viewtopic.php?t=103103
-NB
- Fri Aug 25, 2006 8:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: xml input stage
- Replies: 10
- Views: 3709
Re: xml input stage
This seems the same issue (may be duplicate post ?! ) like one http://www.dsxchange.com/viewtopic.php?t=103093 Please use this to answer. The XML Meta Data Tool scans XML documents and creates DataStage table definitions from them. The tool has its own documentation (XML Developer's Guide) and dedic...
- Fri Aug 25, 2006 7:01 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error loading a file.
- Replies: 6
- Views: 1638
- Fri Aug 25, 2006 6:45 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Retrieve Warning messages at run time
- Replies: 17
- Views: 5821
Re: routines
Hi rachitha, If you have the client installed on your system you can refer the following online manuals, DataStage BASIC Guide Full BASIC reference manual. DataStage Designer Guide - Chapter "Programming in DataStage" Also there is lot of Code available in this forum, based on those you ca...