DSXchange

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.

Hi jwiles,chulett and ray,

Please advise if you have any clue.

Thanks in advance.

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".

Hi all, metadata can be same or be a superset. input link to shared container ---> link1 starting link inside shared container ----> link2 end link inside shared container ------> link3 output link of shared container ------> link4 The link1 contains 20 columns along with the one column DUMMY which ...

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 conversi...

For char function only trim is needed right, do we need to use it for varchar function also.. As varchar will take exactly the space required for the character.

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 ...

Hi all, i am using shared container in my project. The output of the container is EDW_LOAD_KEY column, which i gave in the shared container output link and also all the columns from the input link. But it shows metadata doesnt match with both the links. When i have only that column,the validation is...

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

I'm using Teradata EE stages to extract and load data from/to teradata tabels in a job. I'm frequently facing an error: "TeraSync: error advancing to state 2.180,663,400, unable to execute 'update <Sync_database>.terasync set ctlstate = 2, eventCount = eventCount + 1 where cookie = 1169485346'....

Hi all, Source(SQL Server) ---> Copy ---> OCI(target) Most of the source columns are NVarchar. I am giving in the source query itself as varchar along with unicode to extract the data without giving as nvarchar. I am getting the data properly , but the following warning comes in the log. src_INTERNA...

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 modi...

Hi chulett, How to update the parameter file everytime. If we create a parameter set for this specifically, how to access it. Please explain the logic. Is the parameter set will be a text file. And in the value tab of the parameter set i have to give the initial value and update it everytime?. If it...

Hi all, For incremental extraction from source, i take the last run's date in a text file, which can be used as reference in lookup and i can pick up the records which have greater date than that from the source. If there is a table for keeping the last run's date value means, then there is no need ...

Thanks karthikeyan, Thats worked out.
Now I am able to run the jobs using functional id after adding it to my ds jobs group.

One again Thanks to you!