DSXchange

I did select all options in tracing tab except REPORT ROW DATA and still it does not show me the SQL sent to DataBase in the Job Log.

Am I Missing something here ?

Thanks

Hi I use ODBC Stage to get the data from DB2. I would like to see the SQL which is sent to the database from DataStage in my job logfile. How do I do that ? Also, how do we know what SQL has got executed in the database. I know we can look at view SQL tab to see the SQL which is been sent to databas...

Thanks Ray and Arnd... I think what Arnd says is happening in this situatuion...It looks like it's not able to write to the seqential file after the sorting. I have mentioned stdout as my output file...but it does not work. Anyway this is my shell script which is called from filter command... fyi......

Ray - In your post you said - This error is probably unrelated to any filter that you may have. $DS.SEQOPEN is the function that opens the text file itself. But If I remove the filter command and run the job, it writes to that file without any problem. Does this ring a bell ? Arnd - Thanks for your ...

Ray -

we are using IPC stage to improve the performance. Atleast thats what I was told...

Kaps

Arnd Thanks for the inputs. I checked the path, name and permissions and they look good. I don't know what the problem is... Please tell me If I am doing anything meaningless...this is what I am doing... ODBC Stage-->ipc-->Seq file stage In the filter command of seq stage I am calling a shell script...

Thanks for the Inputs.

Please let me know what this error means...

DSD.SEQOpen GCI $DS.SEQOPEN error 11.

Thanks

Ray - Thanks....Yes. I do have execute permission to the shells. Now I have used a file name instead of /dev/null in file name column of sequntial file. The shell returns the non zero value(return value is empty) which is written to the output file mentioned. But It runs fine If I just ran the shell...

Thanks for your reply...Ray... I still have problems...My shell script gets input from stdin and writing to stdout. If I run just the shell it runs fine but It fails when I call this from DataStage. I have used /dev/null in the file name... My Filter command look like this... /xxx/xxx/xxx/xxx.sh std...

Ray - Thanks for the reply...

Does anyone know how to export a table definition from command line ?
I know It's possible to export jobs and routines. but could not figure out a way to export Table Definitions...

Any input is appreciated...

Thanks

All I am looking for help to use filter command...what I am trying to do is to execute a shell script from filter command which needs 3 parameter as input. first parameter is the name of the file need to be sorted which is what I am reading from DB2... Job looks like this... ODBC Stage-->ipc-->Seq f...

Kenneth

I found the env variables in DSParams file.

Thanks

Kenneth

Thanks for the reply. I think I did not make it clear.

I want to access user defined DataStage Environment variables from AIX which are defined at the project level.

dsenv file does not have those...

Thanks

All Can you tell me how we can read DataStage Environment Variables in AIX ? I know all those env variables must be written in someplace in the repository. I am looking for ideas to get them to AIX so that I can make use of them to interact with other tools like CoSORT etc... I would appreciate any ...