DSXchange

Thank you Ray, I have tried the Orchadmin Cp command and it worked..
Is it advisable to copy datasets using this command.. Are there any possibilites that the dataset would be corrupted.

Hello Is it possible to copy a dataset with a orchadmin Dump command. For eg. if i have created a dataset as ABC.ds in a Job and i want to have a copy of the dataset as ABC_DATE.ds. In my 2nd Job can i read the ABC_DATE.ds, is there any possiblites, if so a seperate Datafile n descriptor file will b...

Hello I have a DB2 connector stage as my target , its a simple Dataset to table load, and i have the options as Write mode: BulkLoad Table Action : Append Before/AfterSQL: No Load Control : LoadMode:Insert Bulk Load with LOB or XML Columns : Yes But for each run the table is getting truncated and lo...

Thank you so much for theinfo,
The error message was : "Type mismatch " for that particular column,
I am not sure, if i can create a schema file and pass it while running, if i want to pass the schema file a a parameter, how can i do it ..

Thank you so much for theinfo,
The error message was : "Type mismatch " for that particular column,
I am not sure, if i can create a schema file and pass it while running, if i want to pass the schema file a a parameter, how can i do it ..

Yeah, I was able to test without a Schema File, i was able to load a dataset into table. It took the Dataset metadefiniton implicity from the datastage. There was one scenario, For a particular column the Nullable property was set as Yes in the source (dataset) where as in target( table) at the Data...

Thank you. The datatypes are column names are identical,
My one doubt is is it not necessary to pass the schema file, if so where will i pass it during run time.

Thank you Craig, So i will use Open command for pre sql and Close command for Post sql..

Hi I have a Job structure as Source(dataset ) and target is (database) I want to pass the Dataset file name as Parameter and the Table name in the target as Parameter and enable runtime column propagation as I want to load 40 different tables from different datasets. When I want to run this Job, how...

Hello Team, Please help me out to understand this. There is a Option In Netezza Enterprise stages under Property tab, Options. we have 2 options : 1.Close Command Specify an SQL statement to run before the insert array is processed. You cannot commit work by using this option. The statements are exe...

Hello

Does Netezza Enterprise stage as options for Before and After SQL.
The current version which i am working on is 8.1 and I dont see a option in netezza enterprise stage to have Before and After SQL

How it can be specified in Netezza enterprise stage

Hello Team I had a Job with Dataset as Source as DB2 connector stage as Target I have modified the Job by replacing the DB2 connector with Netezza enterprise stage. Its a direct load from Dataset to Netezza Database, the job is aborting due to the error main_program: Fatal Error: Type mismatch for f...

Hello,

I have a Parallel Job which has Datasets in it, I have run the Job with the config file as 2 nodes, Now if i run the same job in the same environment with a Diff config file of 4 nodes, it doesnt work,

Can i have the scenario vice versa, will it work, if so kindly help me to know how.

In a CobolCpybook, when we have metadata with two Occurs depend on Columns (2 table entries), DataStage is not able to import the metadata itself.

If any one has any suggestions , Please provide your valuable suggestions on it