DSXchange

Server routines force you to know DataStage BASIC. And there are probably a lot more C programmers out there than there are DataStage/UniVerse BASIC programmers. What's the point? If you're going to program, you need to know/learn the programming language of choice for the application. Ray, i agree...

i can uderstand that i can use Write Method as Upsert and edit the generated SQL. from the definition of upsert Insert if update fails OR Update if insert fails , whereas i want to do only insert i can say Upsert Order "Insert then update" and change the generated update statement to updat...

Hi DS folks, can some kind soul point out to me the fundamentals in which the control file is generated. is there any way i can control the defitions for some of the columns. scenario: i am loading the data in Load-append mode in a Oracle Enterprise Stage (ver 7.5) scenario 1: the idea is i want the...

what about Parallel routines , which forces the DataStage folks to know C?? comments please

logic wrote:Hi rekha,
Search the forum , you will find lot of stuff Also read the following post,

Code: Select all

http://www.dsxchange.com/viewtopic.php?t=95903&highlight=search+posting

A quick answer to your question would be performance

It won't work using a Hashed File stage. A Hashed File stage can only perform a lookup against the entire key. Hi ray, thanks a lot for the help. trying to get more clarity , can't i peform something like 1=1 , reference3rdKey=reference3rdKey in the keyExpression to notify the DS to perform the par...

[quote="ray.wurlod"]It won't work using a Hashed File stage. A Hashed File stage can only perform a lookup against the entire key. [/quote] Hi ray, thanks a lot for the help. trying to get more clarity , can't i peform something like 1=1 , reference3rdKey=reference3rdKey in the [b]keyExpre...

Hi DS folks, i have 2 hash files . one is called streamhash and the other is called referencehash. there are 2 keys in streamhash and 3 keys in referencehash . i mapped stream K1 to reference K1 and stream K2 to reference K2. i need the K3 in referencehash for some other purpose. so to shut up DS i ...

source Key-> lookup target Key if targetkey is null (meaning this is a new record) insert into target else -- target key is available in target if NO ( checksummatch(all other columns other tahn status flag)) then update target set status='Inactive' insert new record with status as 'Active' else non...

DSGetLogSummary(hJob1,DSJ.LOGANY,DSGetJobInfo(hJob1,DSJ.JOBSTARTTIMESTAMP)[1,10]:' 00:00:00', DSGetJobInfo(hJob1,DSJ.JOBLASTTIMESTAMP),0) the above code will give the etntries for the last run day and the below code only the last run (and not the last run day) DSGetLogSummary(hJob1,DSJ.LOGANY,DSGet...

You quoted their requirements: Can anybody give an idea on how to get the log for only the last run and not for the entire day. Searching the forum will turn up lots of advice on this, including this post. :wink: The Code Sridhar has given does exactly what he wants , ie, if there are 10 runs on a ...

Hi all, We have a requirement in our project to capture job log for each job in a sequential file. The following routine returns the log for a particular job for the last ran day. DSGetLogSummary(JobHandle,DSJ.LOGANY,DSGetJobInfo(JobHandle,DSJ.JOBSTARTTIMESTAMP),DSGetJobInfo(JobHandle,DSJ.JOBLASTTI...

I have created two after job routines. One adds a trailer to the output file from a job and the other is meant to add a header. The problem is that although the Write Trailer works fine, the Write Header routine is adding the line at the bottom of the file and not the top. Is there a way of using a...

kcbland wrote:You are probably getting fouled up with the quotes.

Works like hell , if the quotes are removed . lesson learnt : Dont play with Quotes. thanks for the suggestion

Hi All DS Folks, i am creating a file by re-directing the output of UNIX echo/print command. the command goes thr' (Meaning there is no error after the command is executed) but no file is getting cerated. i would very much appreciate any help on this is. sample code like UNIX_COMMAND='echo "':F...