DSXchange

Hi Can you try with the follwoing formate

Oconv(Iconv(DSLink3.FieldName,"D-DMY[2,3,2]"),"D/DMY[2,2,2]") Or

Oconv(Iconv(DSLink3.HIREDATE,"D DMY[2,3,2]"),"D/DMY[2,2,2]")

Hi thanks for you reply I am doing the same I am taking the source file and doing the lookup with 3 key cols(fac,pol,end) and comparing those 3 keys if same then append. It is appending correctly, but it is creating one more record and appending the data. EX: out put is showing as follows, insted of...

Hi,
I have 4 fields from source those are
fac
pol
end
comm

if fac,pol,end is same then I have to append the comm to existing comm, without creating new record.

Thanks in advance.

Hi I have one data file. it contain only one column with 27000. I copied this file from desktop into unix. This file dosen't have delimiters and quote chars. I am reading this file as Fixed width file. But I am getting error like ' columb unexpectedly terminated with error'. Can any one sugget me ho...

Can you please give me the formate how to convert the date into charactor.

example 2000/09/23 into 20000923.

Thanks in advance

Hi ,
I want to convert date or time stamp in to charactor . In server job we don't have functionality like DateToString().

Required output date is Char(8) yyyymmdd.

Hi
I have one date field which is timestamp. its formate is mm/dd/yyyy hh:mm:ss.
I want to convert that time stamp to date as yyyymmdd or yyyy-mm-dd

Can any one suggest me on this.

Hi
I am loading data from flat file to hash file through transformer without any constrain.

My question is I want find the duplicates which are not writtening into hash file. how to move the duplicate data into reject link.

Thanks in advance

Hi I am using Data stage 7.5 v, I am trying to create auto numbers in two files. It works fine in 7.1 v. We are recently upgrade to 7.5v , it is giving error, How to rest the KeyMgtGetNextValueConcurrent. Befour stage sub routine I given Exicute TCL , and I spacify the command as UPDATE SDKSequences...

I am using merge stage to get the full outer join from the two files,but I am getting the follwoing error

TEST_merge..Merge_102: Link property retrieval error

can any one suggest on this

ShaneMuir wrote:Can you do a user defined SQL and do the join in your query to give the required output?

Hi,
My suggestion is splits that 19 matches in to 5 or 6 stages then join each other using hash files. It makes some what good performance....

If it possible increase the array size.


Deva...

Hi, I have a job which pulls data from unix box using DataSatge ftp stage, and on sucessful run I need to delete source file. Source file is on different Unix box and my DataStage server is on different Unix box. Any thoughts........ Thanks Mitta Hi, we can do in many ways, it is very simple if you...

Hi, I have one derived column setid, from source let say two cols pol_year, id. My requirement is like if the first record pol_year,id value <> previos record pol_year,id value then setid should increse else previous set id. I am using hash file to read the o/p and comparing the previous val. But I ...

Hi ,

We are using 7.1 server edition. I have one general doubt.

I am hearing from many of them ' don't use link collector stage. Some times it will give problem with out giving any error.

Can any one please suggest on this.

ArndW wrote:Please remember that an empty string, "", is not null. ...

Hi,
Look at the data types . If both are same, then

no need to use stage var/constrain for this. give it in derivation as if IsNull(phone_no) Then N Else Y.