DSXchange

row spliter splits A row, NOT spilts into rows. Taking a simple example. if have column Name with value James Anderson Then using row splitter you can have two column First name=James and Last Name=Anderson. The row splitter stage is similar to the server sequential file stage. The difference is th...

in search give keywords, clean+up+resources and click on "search all terms" radio button, you will find many posts.

Actually, it's Oracle that doesn't always point it out. :evil: Seems to be dependant on the Client version. Well I have wrked on Oracle9i, and i remember in that if i use insert script, and if any of the numeric column has a value greater than its size. The cursor goes to that position and you get ...

I agree with you Ketfos.
Unfortunately Gaurav, datastage doesnt point out the column for which its giving error.
Best way is use sqlldr, if you have many columns else you can also use normal insert script.

There is a caveat in the release notes since about release 5 or 6 that cautions about the use of COMMON storage BETWEEN stages. Since the introduction of row buffering, results are unpredictable if your processing depends on COMMON storage populated in one transform and retreived in another, if row...

You can't. That's quite different from initializing in one transformer and using in anther. Hey, craig i didnt get you. You mean to say it cannot be accomplished? Well I think, I can do it by using $INCLUDE in my current routine, for my actual requirement. After reading everybody post and some sear...

Hi, Under Routines\sdk\RowProc you can find similar routines that come with the product. (at least for 7.5) IHTH, Thanks, for your suggestion. But I have already done that. 8) Nowdays, I always do R&D, and search first, and then if i dont get anything and my deadline is close, I knock the doors...

My actual requirement is : Intialize it in one of the transformer and use it in after-job routine of the same job. So just for testing the function , i created a dummy job. seqfile --->Trans1--->Hashfile--->trans2---->seq in trans1 i am initializing and trans2 i am trying to fetch that value. But fi...

Hey Guys, In the below routine, if i pass a value it stores it in common and if i give argument values as 'Get', it returns the old value stored in COMMON. The below routine works for a process i.e., in a transformer when i keep switching between arguments values. But i wanted to store the value in ...

If i have understood correctly, then you want only that record in hash file which is latest(latest-for a given key column the date column is max).

Soln: Just sort all your key columns ascending and the date column descending.

Shantanu, the basic idea is good, but a stage variable will get executed for each row passed through the transformer... This will probably slow down your job considerably. Better a combination - use the routine, but call it from a parent Sequencer. Thanx for highlighting, sorry i missed out writing...

Alternate,

step1: Write a routine, which would use DSEXECUTE to fire wc -l command on UNIX box and get the count of lines. pass the file name and path as argument to the file.

step2:Call that routine in a stage variable in one of your transformer and get control over the records. :D

Hi, You had mentioned that routine is not correct. If will not matter what date mask you use in Oconv function which is just the display format. You can output the date in diferent formats in Oconv, still it is going to to return correct results, irrespective of the date format. As long as input fo...

ketfos wrote: Ans3 = Iconv(Ans2,"D2")
Ketfos

above is incorrect, the format D2 is for a date value say; 25 MAY 05

Correct format would be:
Ans3= Iconv(Ans2, "D/MDY[2,2,4]")

Well I think, thatz the simplest and fastest way to find it, if you dont have metastage.
If you are unable to locate the routine; check if its a transform


SELECT * FROM DS_TRANSFORMS WHERE DSRID
LIKE '%Name%';