DSXchange

Same sequential file can't be used as input and output.

Since you have used sequential files as outputs in the job.They can't be used as inputs in the same job.Only the reject link is allowed for the output file.

If you want to join the output files, then you can do that in another job.

Adding one more point :
Logic to findout Leapyear:

If (Year%400 = 0 ) or ( Year%100 <> 0 and Year%4 = 0 )

Adding one more point to the above post:
Use Sequential file after Target BD stage with reject link.

Hi,

I understand your requirement is Truncate and Load.
If my understanding is correct then select the following options in Target DB stage,

Write Method=Load
Write Mode=Truncate

Yes you can use Unix command to rename the Target file to the Source file in the after job sub routine property of Data Stage job.

Informative.. Thanks

I guess , the same input files are used(With same data) for both the runs and the output file update mode is append.

If my guessing is correct, change the update mode to Overwrite and test with different input data.

So its better to avoid to have the same table as source and target.

If my requirement is truncate and load, then i think its not possible to use same table as source and target.

Am i correct?

Hi,

Can we use same table as source and target.

Job : Db2stage and lookup file -> Transformer -> DB2stage

Thanks in advance.

Thanks guys..

Yup..

My configuration file uses 2 nodes and i saw two files regarding the dataset in resource disk path.

So Can we remove these two files using rm or any other way.
And if we remove using rm command, will it remove all the information regarding orphan dataset.

Thanks in advance.

Hi,

I got this error When i try to load into DB2 table.

Error:
BuildOutandAudit_tran,15: Fatal Error: Caught ORCHESTRATE exception in parallel process: APT_Archive::BadClass: From: Loading memory archive: Could not find "APT_DB2Partitioner".

Any solutions please?

Hi kduke,

Can you make it clear?

Thanks for the replies guys.

Hi, I am new to DataStage. I created one dataset using ds job and i removed the dataset using rm command from unix( Without orchadmin command). My question is, Does any information exist regarding dataset or total information has been removed. If exists, what kind of information exists and how can w...