DSXchange

Are you looking at the correct dataset..
Or check if any other job is updating the dataset.

Ragunathan,

can you check whether there is any processing on the date field.
Do u have any transformers where you will be doing some processing on the date field before mapping to the dataset.

Hi, While releasing the jobs to production we are releasing them through version control. Now we wanted to administer all the changes happing in production projects. To achieve this we are using one script which will access DS_AUDIT table to get the Jobname, User modified, Modified time on a particu...

I think user defined SQL should take higher priority.

Hi Roy, I have a metadate Say, StudName char(25),StudSirName char(20),... So if incoming value in the column StudName "vin" And in column StudSirName is "shelke" I expect Output to be "vin shelke " As it is fixedwidth But currently I getting only values as "vinshel...

Hi Roy, I have a metadate Say, StudName char(25),StudSirName char(20),... So if incoming value in the column StudName "vin" And in column StudSirName is "shelke" I expect Output to be "vin shelke " As it is fixedwidth But currently I getting only values as "vinshel...

Hi All, I am trying to make a fixed width sequential file in PX. All my columns are character type. I am using following options in Format tab of the File. Record Level Record delimiter= UNIX Line Record Length= fixed Field Defaults Delemiter = none Type Defaults: General Pad Char - space This gives...

Thanks to ray,arnd and sainath.
Now i am able to retrieve the value

Hai All, I am having a column which contains data in the following format. value1:value2:value3:value4:value5:value6 and so on. I am reciving a column from a Hash file which contains one number(Specifies number of semi colons ) based on the column i have to retrived the value. Eg: If number is 3 i h...

Jayant,

U can use INDEX function.
Syntax for Index function is Index (string, substring, instance).
This function will return the starting position of the sub string.
If substring is an empty string, 1 is returned. If substring is a null value, 0 is returned.