DSXchange

Time to mark your topic RESOLVED

I guess you have confused the gurus. So no replies...

Use "code" and then specify properly what you need. Then we may understand clearly what you want.

Its helpful that when you mark the topic resolved you should also provide the solution like how you did ?

Its helpful for other users.

There are two types of routines: 1) Transform routines 2) Before-After job sub-routines *Before-After routines could be used/written within Transformer or even Shell scripts are used/written. For transform routines in the repository just right click on Routines and make new server routines. You can ...

You are in wrong section. Post it in Parallel and delete from here please.

Please mark the topic RESOLVED

umamahes wrote:
#include <dsapi.h>

when i compiled this code i am getting the fowlling error

"dsApi.C", line 1.10: 1540-0836 (S) The #include file <dsapi.h> is not found.
make: 1254-004 The error code from the last command is 1.

Not sure but may be $INCLUDE DSINCLUDE DSAPI.H

Using Hashed file stage or using shell script in before job subroutine.

WOW

Thanks buddy for resolving otherwise it would have been a issue of the day. As KrazyKoolRohit said :

Something fishy with IBM

Blame it on Rio (IBM)

Its becoz you were not here SIR

We missed you and even IBM

nkln@you wrote:I noticed that only when I click the Oarcle Stage in my JOb, The designer is getting hanged.

What is the problem with Oracle Stage.
I was using ORA9i stage

Are you doing view data in ORA9i ?? If yes it will take some time to retrive the data, its not hanged then...

Can you open Director and Manager ?

Can you post the generated SQL ? Check the TO_DATE() in it.

I guess its possible from TX but you can check the existence of input file by using before job subroutine "DSWaitForFile"

I have sent you a PM check it out and respond. Try this in Shell script and run it- #Shell Script name ganesh.awk BEGIN { FS=OFS="|" } tolower($1) == "property" { _prop=$0 ; skip=0;next} $2 == "" {skip++;next} !skip { print _prop; skip++;next } 1 Run it using - nawk -f ...