DSXchange

What is the procedure to stop and start the database server which holds the metadata in 8.1. and what is the order to start all servers like ds engine/db server/services...
oracle is the database server for us.Thanks

We need to get xml tags also for both B and C. Actually we need to get only two columns like that. but both the columns has long text data so that we have assigned data type as CLOB.

Appreciate your help if you can advise the procedure of getting those output with tags. Thanks

We were required to store the data(merge of two source columns) in xml format of a target table column. The Req is like this Source table has columns like A,B and C. Target table has two columns A and D. col A directly can map to target A but source B need to be display in first line and col C in se...

Can any one advise how to resolve this warning

Implicit conversion from source type "dfloat" to result type "sfloat": Possible range/precision limitation.

Reading .csv files using sequential file stage. source file has few pading char..if we remove those pading char in the source then we are able to read that file. now we are required to read source file even it has pading char.

Thanks much

we are not able to read souce file(.csv) with sequential file beacuse the source file has pading char. any advise to read the source file even it has pading char.

Thanks

what is the format i can use if i need to keep the date like 19 sep 2008.

I am getting this error while converting stringtodate. source is .csv file and datatype is varchar have to keep date in oracle target. using the ds version 8.1 I am using the code: StringToDate(SRC.DATE,'%mm/%dd/%yyyy') getting resulet like ************** APT_CombinedOperatorController,0: Data strin...

Can't we write any code in the ds job! to get microseconds also.

I have Timestamp like 2008-02-28 19:50:32.428586 in db2. I need to convert this in to oracle target db like Timestamp with micro seconds. can any one help me giving sugessions. when i keep taget datatype as timestamp it is giving like 2008-02-28 19:50:32.000000000AM. but i need with microseconds. Th...

Getting connect broken error when kick of the dsjob. job was compiled successfully. when the dsjob run getting immediatly connection broken error. can anyone experience this problem before in 8.1. Error was like this....Error calling subroutine: DSR_EXECJOB (Action=5); check DataStage is set up corr...

Unix admin restarted unix box where datastage 8.1 was landed. datastage engine was running automatically when rebooted the unix box. but not able to connect ds client and also not able to connect webconsole. I have stoped and restarted the DSEngine again. even though it is not working. Is there anyt...

How can we read from db2 stage if the length is varchar 700.

Is there any issue writing data in to CLOB in oracle!

I need to get an advise from you guys and figure out what are all the codes have to use for them. Appreciate your help

Thanks