DSXchange

I cant sort. The data comes in a manner that ordering it is not advisable.

Hi, I have a record like this: |Number|Name|Country| |9|Henry|France| |10|Rooney|England| |Number|Name|Country| |10|Zidane|France| |Number|Name|Country| |3|Cole|England| I want the output to have only the first column header and then the data: |Number|Name|Country| |9|Henry|France| |10|Rooney|Englan...

The approach doesnt work unfortunately
Anyway thanks

Hi All, Is it possible to call an .sql script containing the Select statement (to read fromDB) in a Teradata API stage? I mean instead of typing the SQL statement in the SQL tab in Teradata API. Likewise, would it be possible to do the same if I were to load into Teradata(insert SQL file) Thank you....

Hi Guru, This is what I did. TeradataAPI ->(Transformer optional) -> Teradata In the Source table, I loaded the table and connected to the teradata database, in the target,however, I called the stored procedure to do the inserting in the SQL-before. Its not working unfortunately. The table definitio...

DSguru2B wrote:Do it in the before/after sql of DRS stage. ...

Do I need to call the procedure in both before and after or just BEFORE?
Sorry to bother you..

What version of DataStage do you have.? If 7.5x then you must be having STP stage. Use that. If you are expecting return parameters then doing a simple "call stp" from before/after sql tab is out of question. Calling a parameter from odbc stage has its limitations. It can only support IN ...

The stored procedure is inserting some values into a specific column. The job should call the stored procedure and populate the column.

Hi Guru, Thanks for the reply.Assuming Im trying with Teradata, ODBC ---> TERADATA In the ODBC stage, do I select using Stored procedure in the Ouputs-General Tab and then enter the stored proc name in the text box? Or theres no need to do this..instead in the target Teradata stage, call the stored ...

Hi, Thanks for the reply. The procedure should insert some values(all values are specified in the procedure) into sybase and teradata database.Thats what the procedure should do. Would it be fine to have a stage like this: /-->SYBASE ODBC --/-> TERADATA In the ODBC stage, import the stored procedure...

Hi, I need to call a stored procedure(sybase and teradata). Would it be better to use a routine or normal ljob creation? Could someone show me the stage required if I would need to create a job? This is what I did... Teradata API -TRANSFORMER -TERADATA It doesnt seem to make sense to me though...as ...

Heres the script #!/bin/ksh while read AGE V_PATH DELAY do cd $V_PATH for file in $(ls) do if [[ $(( $($HOME/./fileage $file)/60)) -ge $AGE ]] then echo $file >>outputfiles.txt fi done >outputfiles.txt final=`wc -l outputfiles.txt|awk '{print $1}'` if [ $final -ge 1 ] then echo $final "Unproces...

The path /home/A/B/script.sh is the path to the script on the unix server. Apparently the default DS path is not this, so I need to set it. Could someone tell me how to change the path please?


Thanks
Julia

Is it fine to do this in job control?

UnixCmd="sd.dfd.com" (hostname)
CALL DSExecute("UNIX", 'sh -x /home/A/B/script.sh', ScreenOutput, ReturnCode)

I ran it and got the same warning "cannot open file" like the previous case.

THe script reads from an input file. When I execute it normally it works, but when I execute from DS, it says cannot open file in the log. I checked the rights and everything looks ok.

Thanks

Julia