DSXchange

Oh it has been removed buddy, I'm pretty sure of that. I've done 8.5 installation last week for one of our clients, all went smooth but I got surprised there is no Enterprise stages. I googled, and got nothing, not even on IBM website. Had to call IBM and they started to mumble for a few days, unle...

Unfortunately all processing is done in order...

If you want value of second record in first record then sort the data in descending (reverse) order first and then process through transformer...

use stage variable store value of eflag of previous record and use it with next record...

Name tells you the difference... update then insert will update first and if update fails then insert. insert then update will insert first and if insert fails then update. In "insert then update" update will only happen if your key have a unique constraint defined on DB level, else your i...

Hi Sudheer, You have number of options to achieve this... Scenario 1 :: 1. Read the source file using sequential file stage with First 6 Char as Col1 and rest all data in Col2. Option 1 : Job 1 :: Split into physical files on bases of value of Col1 Next Job :: Read files with Sequential File stage w...

Ray,

It is not Sybase limit because I am getting expected data (complete 400 Char) when i execute procedure in Sybase, but when i call same procedure in Datastage through STPPX stage, data is getting truncated to 255 chars...

Sunny

Hi,

We are tying to extract data from Syabase DB through STPPX stage. length of column is Char(400), in Output i have tried selecting Char 400 as well as Varchar 400.

Problem is Data is getting truncated after 255 Char...

Can anyone please help in resolving this issue.

Sunny

Anyone!

We have an ETL job running on one node where we are using an Oracle Enterprise Stage (running in sequential mode) to fetch the records from the oracle DB table (which is being replicated using CDC). Then we do some simple transformation in transformer stage and then write it into a sequential stage....

Hi,

Please trying after removing space after @FM as below

Trim(Convert(@FM,"",#Command_Execute.$CommandOutput#))

devidotcom wrote:Hi All,

Trim(Convert(@FM," ",#Command_Execute.$CommandOutput#))

Mannu, What I understood from your query is, target XML structure is not yet finalize (or could be Dynamic) but you want to give XML structure at run time... For this, use XML Transform stage after XML Output stage and use XSL to write the structure of XML. You can modify this XSL anytime without to...

ray.wurlod wrote:Why VarChar(10) if the longest string that will ever be stored in it is seven characters?
...

OK.. make it 7, anyways that was just an example...

to my luck , all the source coulmns are varchar fileds In that case, you have to do NULL handling in Transformer... check if source column is "" in stage variable and assign some value, and in take a Dummy Link Out from Transformer with Constraint on stage variable = "NULL" and ...

Hi All, I have the below requirement to be done in datastage PX. 1) If source file is empty, the job and main sequence to be aborted 2) If a non-nullable source column receives Null values in the source file, then we need to stop the loading and abort the job Can anyone please suggest me on how to ...

If it is NFS drives you are using, then changing the location won't create any problem I guess. Create a link in AIX for your destination folder and map "XmlFiles" folder to it. Hi, This is exactly what I am doing at the moment, I was just curious to know if there is any other alternate t...

Hi, Strange requirement... :wink: There is an alternate way too... just simply use a copy stage, with entire partition and this will create as many duplicates of you input depending upon you number of nodes in APT Config File. If your APT Config file is of two nodes, this will create 2 records per i...