DSXchange

I have a datastage job that reads data from a Sybase table (CHAR Columns) and loads to a Oracle table (CHAR) Fields. There are a few rows which had only spaces as the column values and this data needs to be loaded to the oracle tables as spaces. My job has APT_STRING_PADCHAR=0x20 set and also I trie...

Thanks Ray,

There are new line characters in the data , for example when i view the data in the table

1
2 Coverage:PPO/M/RX

1 and 2 specify the line numbers , So there is a 'Return' at Line 1

when I view the data in the Sybase table it shows without the 'Return'

1 Coverage:PPO/M/RX

Hi all, Am working on a job that extracts data from Sybase tables and loads to Oracle tables. There is a column in Sybase that has user inputted values which contains some non printable characters. Initially I got the error No default type conversion from type "raw[max=100]" to type "...

Hi chulett, I got the issue now, when i move the file from the windows to unix environment it places a special character in the file for null and thats the reason the job is unable to load the data. ,^@,^@, Its apending the above mentioned characters whereever the columns value is null. I tried to t...

Thanks chulett, I tried to use to_date(:11, 'MON DD YYYY HH12:MIPM')) but got the below error, "Error code: 1858, Error message: ORA-01858: a non-numeric character was found where a numeric was expected " There are nulls for a few records, Could it be because of 'NULLS' that i get the abov...

Hi ,

I checked the datatye in the target table and Its a DATE in the Oracle table

Hi all, I have a job in DS 7.5 which reads from the sequential file and loads an oracle table, the file contains few timestamp columns in the format - May 1 2011 12:00AM. The job runs fine and loads the data to oracle fine in 7.5 whereas in 8.7 am unable to read the file column as timestamp (I tried...

Thanks all.

Hi All, Am working on migrating jobs from DS 7.5 to DS8.7 , There is a instance where they are converting a Timestamp to a string. Am unable to get the microseconds printed out correctly. I used the below mentioned function and got the output as 17530101000000.000 Is there a direct way to get the ou...

I have acces to the shared drive and am able to connect to the drive with (ms/vs4 (my ID)). Am able to connect to the server frm the unix command line and able to 'get' files to the datastage server. But when i try to read the file via FTP staga, am getting the below mentioned error. >##E IIS-DSEE-P...

Hi ArndW,

The shared drive is on windows, We use a common ms/rptteam id to access the FTP location and the DS jobs run via my ID or a common project id.

So if we grant access to the project ID on the shared drive, We should be able to access those files ?

Hi all, We are in the process of migrating from 7.5 to 8.7 and we have a situation where we need to pull data from the FTP shared drive While trying to read a file from the FTP server am getting the below mentioned error Error executing View Data command:##E IIS-DSEE-PFTP-00071 20:58:29(000) <FTP_En...