DSXchange

Doesn't Oracle expect a '/' instead of a space in the default date format? This is the sql that is getting generated INSERT INTO RNKT0.ATTENDANCE (ATTENDANCE_ID,CUSTOMER_ID,HostMember_ID,Club_ID,Attendance_Date) VALUES (:1,:2,:3,:4,TO_DATE(:5, 'YYYY-MM-DD HH24:MI:SS')) Can I change this sql somehow...

Doesn't Oracle expect a '/' instead of a space in the default date format? This is the sql that is getting generated INSERT INTO RNKT0.ATTENDANCE (ATTENDANCE_ID,CUSTOMER_ID,HostMember_ID,Club_ID,Attendance_Date) VALUES (:1,:2,:3,:4,TO_DATE(:5, 'YYYY-MM-DD HH24:MI:SS')) Can I change this sql somehow...

Doesn't Oracle expect a '/' instead of a space in the default date format? This is the sql that is getting generated INSERT INTO RNKT0.ATTENDANCE (ATTENDANCE_ID,CUSTOMER_ID,HostMember_ID,Club_ID,Attendance_Date) VALUES (:1,:2,:3,:4,TO_DATE(:5, 'YYYY-MM-DD HH24:MI:SS')) Can I change this sql somehow...

ArndW wrote:Doesn't Oracle expect a '/' instead of a space in the default date format?

I did try / and -. But both are throwing me the same error

I tried using the conversion Oconv(Iconv(DSLink17.AttendanceDate[1,11],"D MDY"),"D DMY[2,2,4]"):DSLink17.AttendanceDate[12,99] and I am able to convert teh date from the input format to the output format. But Oracle is complaining when I am inserting that to the database This is ...

ray.wurlod wrote:There are also good examples in on-line help for Oconv.

This article is also informative.

Thanks a lot to everyone who answered my query. I was able to get loads of information by going through the documents

hi i have tried using If DSLink4.Field002 = "null" then IsNull(DSLink4.Field002 ) else DSLink4.Field002 and it worked Sorry for the late reply. I tried the above and it worked. As Sun Rays mentioned, the field002 in the sequential file was VARCHAR and it is hardcoded as NULL. But in the d...

Hi, I am trying to read a sequential file and updating a Oracle database using OCI stage. The sequential file has null values in a field1 which is hardcoded as NULL. I am uploading this data to oracle which is a NUMBER field. I tried to define the NULLABLE field as NULL in the sequential file stage....

dprasanth, yes, it does signify something, it is the output format. Please open up the BASIC programmer's guide on your PC and look up the chapter on conversion codes, specifically for the Date conversion. There are examples in there that should clear up some of your questions. Excellent.. thanks f...

You need to do this in 2 steps, first convert the date portion into internal format telling it what the formatting is, then convert it to an output format in the new format. OCONV(ICONV(In.DateColumn[1,11],'D4MDY'),'D4DMY'[2,3,4]):In.DateColumn[12,99] This takes your text date and tells Datastage t...

You need to do this in 2 steps, first convert the date portion into internal format telling it what the formatting is, then convert it to an output format in the new format. OCONV(ICONV(In.DateColumn[1,11],'D4MDY'),'D4DMY'[2,3,4]):In.DateColumn[12,99] This takes your text date and tells Datastage t...

You need to do this in 2 steps, first convert the date portion into internal format telling it what the formatting is, then convert it to an output format in the new format. OCONV(ICONV(In.DateColumn[1,11],'D4MDY'),'D4DMY'[2,3,4]):In.DateColumn[12,99] This takes your text date and tells Datastage t...

Hi, I am very much new to datastage. I am having a sequential file that I am using as an input stage. The file has the following record format 1|517032108|"NULL"|97|"Apr 12 1998 12:00AM"|""|"M"|"SYSTEM"|"09-06-2002"|"N"|"END^...