DSXchange

Please disregard. I see that you just go to the columns tab and set terminatiors in column to yes.

I have a pipe delimited file that I need to load to a hash file for transforms. I use a sequential file to load the hash but I have cr and lf (HEX 0D 5C 0A) in the column of data. This is valid data. How would I go about loading this? DS is assuming the row is missing the columns and blowing up. Her...

I am attempting to add another ODBC entry for a sybase database. I connect to 2 other sybase db's that are the same with no issues. I get the following error: SympoDimensionRT..AGENT: DSD.BCIConnect connecting to Zaventem, call to SQLConnect failed. SQLSTATE=60, DBMS.CODE=7505 [DataStage][SQL Client...

quote: Originally posted by dtsipe [br]I don't understand where is the problem. Do you have multiple input files for Sql*Loader or one step bebore ? I have a directory ("/switches"), under this directory I have multiple sub directories one for each switch that dumps files ("71",&...

Hi, I am new to Datastage and I am looking for some guidance. I need to create a job that will load from multiple directories (each source dumps their files to their own directory), and use Oracle Sqlldr to load the files. All are the same layout. I have created a parameterized Oracle batch job that...