DSXchange

Hi All Is it posible to have a Control Character as delimter in datastage. We have a requirement to geenrate a seq file with ^A as delimter. Please let us know if we have any options to specify it in Datastage. Source: DB2 Target: Seq File Delimiter : 0x01( ^A) In Addition to it , we also need the f...

Hello Team

Any Suggestions to sort out this error please..

Hello Team We are facing issues in reading the data from DB2 and loading into a sequential file . Job Details : Source stage : DB2 Processing Stage: Transformer ( Used to remove char(10) values in convert function ) Target Stage : Sequential File. NLS Map : Project default (ISO-8859-1) Below are the...

It is from one server to another server (both of them are 7.1)

Hello Team We are working on Datastage 7.1 server and having issues in Installing CDC and XML adapter with DS server. Our requirement is to migrate a application from DS 7.1 to DS 7.1 We need to install, configure both CDC and XML adapter when we move the Datastage application. Need inputs on the in...

Hi Ray

Thank you for the Soln,
for Money : Numeric(19,4) or 15,2 worked, but for the REAL : Real in Netezza did not work ( the counts were increased while loading into Netezza)

So we had Integer type for Real, and Typecasted it.

Hi Team We have a Job to extract data from SQLSERVER to Netezza. Source : ODBC stage Target : Netezza Connector Stage Options specified : RCP Enabled It is a Direct dump, select * from table name and insert into Netezza. Issues : The SQL datatypes and Netezza dataype doesnt match hence the values ar...

Hello Team I want to have a generic job with RCP enabled with 3 stages, source: dataset Target : Netezza DB stage and a Remove duplicate stage with RCP enabled. i want to pass the keys to the remove duplciates as a parameter for eg: if i run for a table A, which has 2 cols as key, it has to be passe...

I have list of 600 Sequencers, I need to find out the Jobs under each sequence..

Hello Team

Kindly help out to find the list of jobs in a sequencer through a DSJOb command.

Hello Team I have a config file declared at project level with 8 nodes, We have Netezza has our target database.. So whenever we try to load the Netezza or any select stmt triggered on Nz through Ds jobs generates 8 threads in Netezza. so we have asked to run it on a Single thread, basically on a Si...

Hi ArndW The error message I had a column ABC_ID in the source dataset the option was NULLABLE Yes, but in the database the ABC_ID column was a NOT null . so when i try reading the dataset and and load the data, it was showing a type mismatch error.. the Nullability issue is resolved. I just wanted ...

Yeah, But for the scenario where table action is append , write mode is Bulk Load and Load mode is replace, performs the similar opertaion as truncate and Load .
Why it happens like this.. what are the advantages of using this method instaed of truncate and load.

Thank you DSXchange.. marking this topic has resolved.

ShaneMuir wrote:There is an orchadmin copy command.

>> orchadmin cp <from.ds> <to.ds>

Thank you Shane Muir. The orchadmin cp command worked