DSXchange

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

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

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

Refer this post [url]viewtopic.php?t=103074[/url]

-NB

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

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

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

Guys,

Please use meaningful topics headings. Do not use hi...hello..Choose a heading the relevant to your question.

-NB

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

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

[quote="uegodawa"]First use the DataStage Manager to Load the meta data. Manager -> Import - > Table def - > XML TAble DEf Then Open your XML . File -> Open Then click on all text nodes which you want and save the meta data. Now goback to your job, open XML Input stage, then output tab , c...

Guys !

This is a duplicate post. Please do not answer here.

Use the following post to answer.

viewtopic.php?t=103103

-NB

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

Hi Amuktamalyada,

Are you using reject link to capture the reject rows? If yes.. you can examine the rejected rows in a error file/table and find out what causing the warning...there could be lot of reason's like data truncation..

-NB
btw . I am remembering Krishnadevaraya from your name.

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