Thank you
DSguru2B wrote:try thisCode: Select all
DIGITS(OCONV(ICONV(FMT(In.date,"6'0'R"),"DMDY[1,1,2]"),"DYMD[4,2,2]") )
Search found 92 matches
- Mon May 15, 2006 1:15 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DATE FORMAT
- Replies: 10
- Views: 2282
- Mon May 15, 2006 12:55 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Date Error
- Replies: 3
- Views: 916
Date Error
Hi i am getting date in this format 82205 if i use this code OCONV(ICONV(FMT(Link.DATE,"6'0'R"),"DMDY[1,1,2]"),"DYMD[4,2,2]") i am getting the following error: data for column exceeds column width (8), row 33 (approx), data = 2005/08/22 My Target column length is 8 and ...
- Mon May 15, 2006 12:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DATE FORMAT
- Replies: 10
- Views: 2282
date problem
Hi if i use this code i am getting the following error: data for column exceeds column width (8), row 33 (approx), data = 2006/08/22 My Target column length is 8 and sql type is varchar. to be a little more specific, use OCONV(ICONV(FMT(In.date,"6'0'R"),"DMDY[1,1,2]"),"DYMD[...
- Thu May 11, 2006 1:51 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: DATE FORMAT
- Replies: 10
- Views: 2282
DATE FORMAT
I AM GETTING DATE IN THIS FORMAT
EX:
SOURCE IS ORAOCI9 STAGE
42606------------> MMDDYY
120105------------>MMDDYY
112805------------>MMDDYY
TARGET IS ORAOCI9
CAN ANY ONE TELL ME HOW TO FORMAT THE ABOVE INTO YYYYMMDD FORMAT.
THANKS IN ADVANCE
EX:
SOURCE IS ORAOCI9 STAGE
42606------------> MMDDYY
120105------------>MMDDYY
112805------------>MMDDYY
TARGET IS ORAOCI9
CAN ANY ONE TELL ME HOW TO FORMAT THE ABOVE INTO YYYYMMDD FORMAT.
THANKS IN ADVANCE
- Fri May 05, 2006 2:42 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: row rejected
- Replies: 3
- Views: 1222
row rejected
I am getting warnings like these
TABLE1..Transformer_1: At row 2793, link "To_N"
Inserted value too large for column, row rejected.
TABLE1..Transformer_1: At row 2769, link "To_N"
Inserted value too large for column, row rejected.
Can any one help me to resolve.
TABLE1..Transformer_1: At row 2793, link "To_N"
Inserted value too large for column, row rejected.
TABLE1..Transformer_1: At row 2769, link "To_N"
Inserted value too large for column, row rejected.
Can any one help me to resolve.
- Fri May 05, 2006 8:42 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: no descriptor for this position
- Replies: 1
- Views: 1273
no descriptor for this position
I am getting this fatal error,
jobname.tablename: ORA-24334: no descriptor for this position.
can some one help me out.
Thanks in advance.
jobname.tablename: ORA-24334: no descriptor for this position.
can some one help me out.
Thanks in advance.
- Thu May 04, 2006 4:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: file name
- Replies: 2
- Views: 1128
file name
Hi All,
How to create a file name with CurrentTimestamp?
I want to create a file in this form "filename_CurrentTimestamp.XLS"
Thanks in advance.
How to create a file name with CurrentTimestamp?
I want to create a file in this form "filename_CurrentTimestamp.XLS"
Thanks in advance.
- Thu May 04, 2006 11:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date problem
- Replies: 4
- Views: 955
Re: custom sql.
adams06 wrote: stage :oracle OCI
custom sql.
chulett wrote:What stages are you using? Generated or custom sql? ...
- Thu May 04, 2006 11:47 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date problem
- Replies: 4
- Views: 955
custom sql.
custom sql.
chulett wrote:What stages are you using? Generated or custom sql? ...
- Thu May 04, 2006 11:17 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date problem
- Replies: 4
- Views: 955
date problem
these are the souce and target
source oracle
column :U_LOAD_TS sqltype timestamp length:19
target oracle
column :U_LOAD_TS sqltype timestamp length:38
i am getting error
Attempt to convert String value "26-APR-06" to Timestamp type unsuccessful
source oracle
column :U_LOAD_TS sqltype timestamp length:19
target oracle
column :U_LOAD_TS sqltype timestamp length:38
i am getting error
Attempt to convert String value "26-APR-06" to Timestamp type unsuccessful
- Thu May 04, 2006 11:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Attempt to convert String value
- Replies: 8
- Views: 3650
error
TIMESTAMP(Iconv(date column,"D DMY[,A3,2]"))
its returning a NULL value
its returning a NULL value
pkomalla wrote:You can use the following derviation in the transformer
TIMESTAMP(Iconv(date column,"D DMY[,A3,2]"))
It works....
TIMESTAMP is in DS Transforms/built-in/date
- Thu May 04, 2006 8:05 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Attempt to convert String value
- Replies: 8
- Views: 3650
conversion error
Hi Ray, Input is coming in this format 04/26/2006 14:19:11 but i am getting error as TABLE1..Transformer_1: At row 200, link "TO", while processing column "U_LOAD_TS" Attempt to convert String value "26-APR-06" to Timestamp type unsuccessful how to resolve this. Thanks ...
- Wed May 03, 2006 11:59 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Attempt to convert String value
- Replies: 8
- Views: 3650
Attempt to convert String value
how to convert a String value "02-JUN-04" to Timestamp
- Tue May 02, 2006 3:02 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-00942: table or view does not exist
- Replies: 10
- Views: 4901
the target table is there but still i am getting the error- Tue May 02, 2006 2:39 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: ORA-00942: table or view does not exist
- Replies: 10
- Views: 4901
ORA-00942: table or view does not exist
i am getting this error can some one help me out
x..y: ORA-00942: table or view does not exist
Thanks in advance
x..y: ORA-00942: table or view does not exist
Thanks in advance