modify stage error

[dsscholar]

Hi All,

I gave the following expression in modify stage

timestamp1 [:timestamp] = [StringToTimestamp] timestamp

old_columnname is timestamp and its a varchar field but contains timestamp value. So i am converting to timestamp datatype. Am getting the following error.

main_program: Error parsing modify adapter: Error in binding: Error in destination field selector: Expected integer, got: ":"; input:
timestamp1 [:timestamp] = [StringToTimestamp] timestamp

Please help me correcting this syntax .

[priyadarshikunal]

I gave the following expression in modify stage

timestamp1 [:timestamp] = [StringToTimestamp] timestamp

From what i remember the function is something like
TimestampFromString()

Modify stage doesn't take transformer functions.

[dsscholar]

Thanks for the reply. But still getting the same error.

[chulett]

Similar perhaps, but not the same. As noted, the Modify stage uses different functions from the Transformer and they are all documented. Looks like what you need is timestamp_from_string().

[ray.wurlod]

There are no square brackets around the new data type. These are used only to show optional syntax.

Code: Select all

timestamp1:timestamp = timestamp_from_string(timestamp_string)

[dsscholar]

Hi ray,

Job ran successfully. But the converted column value is null. The input string is of nvarchar datatype, which i extracted as varchar with unicode from the source itself. After that i placed modify stage to change to timestamp.

Please advise to convert nvarchar to varchar and from varchar to timestamp. Because for remaining columns, i just want to pass as varchar.

Thanks in advance.

[ray.wurlod]

If it's Unicode you need timestamp_from_ustring() function.

[dsscholar]

Source is sql server and the datatype is nvarchar. I use varchar with unicode in datastage source stage. But for all the columns am getting the following warning.. how to eliminate that.

nvarchar in sql server is nothing but varchar with unicode right? I would like to change to varchar. Any conversion needs to be done here.


Thanks in advance.

[dsscholar]

Warning message :

src_INTERNAL_STMTS: When checking operator: When binding output interface field "timestamp" to field "timestamp": Implicit conversion from source type "ustring[max=20]"to result type "string".

[ray.wurlod]

Specify Unicode VarChar(20) rather than unbounded non-Unicode VarChar in the stage that threw the error.

[dsscholar]

Hi Ray,

I gave as varchar (sqltype) and unicode(extended). Still throwing the same error.

Source is sql server : datatype of columns(nvarchar)
In datastage, i use sql server enterprise stage and am using varchar with unicode to extract data.. But getting that warning message.

[ray.wurlod]

VarChar or VarChar(20)??

[dsscholar]

you mean size 20 with varchar datatype or something as varchar(20)?

[ray.wurlod]

I mean precision 20 with data type VarChar.