DSXchange

hi, I have one datastage job, in it's job control, I add one command as below Call DSExecute("UNIX", "ascript.sh", Output, SystemReturnCode) then I compile and run the job. the ascript.sh should create a new file in my unix direcroty. after the job finish, I can not see any file ...

I do not know how you insert timestamp into hashtable. I just did a test, wrtie timestamp as string into hash file, the field data type is timestamp. There is no problem at all. the timestamp I am using is like this, yyyymmddhhmmss, for exsample 20060606124731

cat two file. but why you do that? how do you deal with a file with two parts of different meta data?

it is usually because your sequtial file format is not right. I have met this error several times. suggest you to view the data to make sure either of file format is correct.

I think nothing wrong with your constraints.
check your database and input data are matching.

if your source date format is varchar dd-mm-yyyy,
just use substring function to convert it to yyyymmdd.
Orcale will work very well on this string.

Anee wrote:Hi changming

It still doesnt work. Infact i doubt the stmt u wanted me to add in the transformer stage is correct.. is it possible to concatenate the way u told???

sorry, I tried, that is wrong. sorry for misleading you. Check your file whether it is writen by other link.

what is stmt anyway?
try to cat in this way
link.field :''':'''

I do not know why you need to split a file to so many files. You can use hash file and multi instance do achieve this. you need to built to job, first job just read the file and write only the first one distinct column into one hash file then write into a txt file. seconde datastage job will be call...

I assume you are trying to replace something in maps? If so yo can do it this way also. First Export the map to xml file, then do search, replace and save the xml. Then re-import the xml file as map. you will see all the changes. Regards, Kiran Is there a way to do a wildcard search and replace ? S...

I agree that most business validation in maping rule or input cards. but there are some exemptions. for exsample, in input card, it is eaier and convininent to filter some data out of scope. If we use input card to extract the data which we want, that will save a lot of efforts to capture some tiny ...

that is worked for me well. do not ask me why, i learned from other's paste.

I use a merge stage to do a many to many join, everything is working fine, just a little problem confused me few days. the null value in the first line of the merge stage output is transformed to 'Yes' for some unknown reason. This only happened on the first line. any one has met the same problem? i...

I have a job read and read same hash file. I disable cash and lock for update. performance is bad. (not acceptable).
be careful to use that lock for update option.

check your mapping in merge stage, make sure all the key for joining two files are used.