DSXchange

I have a simple job that loads data from flat file to transformer the to 2 odbc(SQL Server 2003).1 for rejects .I have 1 constrain that reject data"LN_TFM_ITC.Employer3 = 'K' ".When running the job i get this error"ITC_Load..SEQ_ITC_File.LN_TFM_ITC: read_delimited() - invalid quotes, ...

version 7.1
sun solaris

Can i use CA UNICENTRE to schedule the jobs in Datastage?

Are you able to write to this table using something other than Datastage like Query Analyzer? yes i can,it works fine.In datastage no error messages in director cause it freezes and i have to kill the job before i can check.

odbc->tranfomer->flat file->transformer->odbc the problem start when it goes to the last odbc it freezes.if i take out the last odbc then it works fine. using odbc(IQ data warehouse.The source is over 1million rows but the target is to get the last 30 days of information.There is a constrain for tha...

I am new in datastage enviroment so please be detail in your solution DataStage freezes when he loads data from IQ to SQL Server tables for a 1000 rows.He used source stage,transformer then to a flat file,that works fine but from flat file to sql server then datastage freezes.He stops all the jobs a...