DSXchange

Thanks,
It worked....

-R

can I head or tail a flat file and use them as parameter to a job.

We have to run our jobs with parameters coming from a flat file.

Any suggestions?

I have heard that I can use a hash stage and query it using routine to get the parameter file. But again its a parallel job.

-R

Did you Use
and let us know,

-R

Its Parallel.
Its a typo while I presented this. Sorry for ALL confusions.

Yes,

5.1 works just fine as version before.
Try example in /example folder to ensure they work fine.

Recently updated my drivers and had no problems.

Good Luck!

Confirmed something.

rsh is must to invoke your slave nodes.

Creating a UNIX symoblic link to rsh pointing to ssh may work, did any one implemented that and had luck?

telnet is optional.

Is Telnet mandatory or can be replaced by ssh?
Also is rsh mandatory or it can be replaced by ssh?

If so, anyone implemented? Appreciate you showing the best way out.

Thanks
-K

Using TeraData provided tdata.so as driver.

driver works fine for server job.
causes Segmentaion fault and Error Code 139 in Parallel jobs.
Any work around, answer, patch?

-K

I believe there is a tool called "DataStage Environment Variable Transporter" for backing up and transferring Env. variables...

make them part of dstage group, where dsadm is part of...

You have to configure your env. before your run ur PX job... Especially apt file... See Manager tools configurations.

You also need to define env. for your DBMS viz. Oracle, DB2 etc.,

refer to DS install and upgrade guide pdf....

create a routine and in routine use this one

Ans = @NULL
If IsNull(TheDate) Then RETURN(Ans)
TheYear = TheDate[1,Len(TheDate)-3] + 1900
TheDay = TheDate[3] ;
DSJulianDate = TheYear : "" : TheDay
Ans = Oconv(Iconv(DSJulianDate, "DYJ"), "D-YMD[4,2,2]")

RETURN(Ans)

I want to remove only the trailing numbers from my data

e.g.

financial 2000
production 2001
5th annual reconcilation

should be

financial
production
5th annual reconcilation

I have my rule set defined and want to add this to it...

Any guidance from gurus?

Thanks in Advance
Kewl

I found a solution myself

Field(DSLink2.Field002,"-", 1) will help me

Thank for - - - - -

Kewl

wait for file activity is perfect for you.
I presume wildcard doesn't work here. You should have a specific file name.

Clarification do you have server on the machine where the file arrives?