DSXchange

The answer is "not directly". DataStage is an ETL tool; what kind of transformation would you expect to perform on an image file or a BLOB? Those who have had this requirement have tended to perfo ... Actually not transform.. i just need to move the image in the file to oracle using datas...

Do anyone know that whether datastage can transfer Image from file to BLOB field in oracle?? Urgent Help Need!! SOS

Hi all I have a special character Ctrl Y in the data and try to load the data into the sequential file (unix,Datastage version 6). I've tried several ways to ignore it but still not managed to get it done. The ways i've tried is belowed: OCONV(String,"MCP") This will convert the special ch...

thx guys
I've use Routine DSExecute to solve this prob.

thx guys
I've write a script and run it with DSExecute. It succeed.

Anyhow i still need to do some char parsing in the script coz DSExecute to unix strip all the " ' eventhough i put an escape infront of the special char in DS routines.

thx guys
I've use Routine DSExecute to solve this prob.

Hi, all i'm trying to write a routine which will output some of the values to a file in sun solaris system. At command prompt i've tested echo "(" >> test2.sh successfully append into test2.sh but it fails if i use DSExecute. The first command in my code suceed but the 2nd one failed. comm...

i'm so sorry. I didn't attend any datastage training and i need to do one or two job using datastage to facilitate my application to obtain the data in faster manner. Now i'm trying to execute a stored procedure from oracle. From the documentation i follow step by step how to import and use apply th...

Hi all,

I have a job calling oracle 9i stored procedure at ODBC stage.
I have successfully import the stored procedure, and applied it on the stage.

but i've difficulty in how to make the job run.

is there anyone can help a datastage beginner?

Thx

the below is the succeed code in oracle syntax sqlplus -S dev_pds_my/dev_pds_my@devpdsmy @/datastage/Ascential/DataStage/Projects/PRS/test.sql So, i changed the command as below command = "echo sqlplus -S dev_pds_my/dev_pds_my@devpdsmy @/datastage/Ascential/DataStage/Projects/PRS/test.sql"...

After i changed the command to actually excuting a script file, different error has shown. command = "echo @/datastage/Ascential/DataStage/Projects/PRS/test.sql|sqlplus -S dev_pds_my/dev_pds_my@devpdsmy" Result = SH: sqlplus: not found Is there anything do with this command cannot executed...

hmm.... after i've changed accordingly the same error shown... I'm using DS version 6.0.1.11. Any idea why? :( TEST #1 ******* Arg1 = 1 Test completed. DSLogWarn called from : SQLPLUS Message to be logged is... > Error when executing command: echo EXECUTE DATASTAGE_TEST_SP(\'abcd\');| sqlplus -S dev...

Hi all, I'm trying to write a routines to execute a stored procedure from oracle. My Stored Procedure expecting an varchar input and will return a varchar output as well. I get an example from the forum but i have the below error, when i try to execute the routines. Can anyone help me in solving thi...

Actually i faced the same problem eventhough i set the default database name to PDSDB. I still hv the same error. According to the Sybase DBA, this error message is because i use a begin trans and end trans for the sql. Just wonder is there any setting in datastage could treat each sql as a transact...