DSXchange

I think table is locked in the database.

Thank You.

Thanks

Thank You.

Thanks

Hi How we can implement the inner join in the ServerEdition. I got a business requirement as a Sql Query. I implemented the same query in the DS ServerEdition by using 2 DRS stages as source and one Transformer. I joined single column in the Transformer, Based on the join i derived some columns from...

Try to read the file in this way ABC_MMDDYY*

I didn't enable the RCP in the join Stage.

Thank you

Hi All I am getting the below warnings when i use Join,Merge and LookUp stages. From DataStage director we can supress these warning but i want to do the same in the job. Please guide me on this. These are the warnings: JOIN: When checking operator: Dropping component "MATERIAL_DOC_YEAR" b...

Hi Everybody I am reading an XML file from Sequential file stage. with help of only one sing key column with Varchar 255 After that i am processing that XML file with help of XMLInput Stage. In the XMLInput stage what i did is. In Stage tab: Transformation Settings: A) I enable Repetition element re...

If manager is a client tool then why it showing the unix directories when i was accessing flat files why not XML files.

Hi Everyone I need to access XML files but I am very new to XML stage. My problem is whenever i try to import the metadata from XML meta data importer. I am unable to see the unix directories. by default it is showing windows directories. but my DataStage server configured in UNIX. All my source XML...

Thnaks for your valuable input.

As per the client requirement I can't handle any null values and I can't eleminate TrimLeadingandTrailing function. The same thing I Implemented in couple of jobs I didn't get this problem. Please provide your inputs.

This is the warning I am getting

APT_CombinedOperatorController,0: Field 'Field002' from input dataset '0' is NULL. Record dropped.

Dear All I am reading a file from Unix through Sequential file Stage it contian 82 columns all columns I am reading as NVarchar and Null is Yes. After that in transformer I am upplying TrimLeadingTrailing function for all the 82 columns and sending into the Target Database SQLServer 2005. This job u...