DSXchange

i am using Datastage server 7.5 (server edition)... we have a stored procedure stage.

hello, you have to create a procedure in database having input parameters that you require for your processing. Next in Stored_Procedure stage goto --> syntax tab -->give the name for procedure --> uncheck generate procedure call ---> then call your procedure like for example BEGIN p2('#val#'); END;...

Hello Ray i tried deleting category with jobs inside it as well as empty category from client machine, it deletes immediately and refreshes.

Please search for forum, their is some custom routine developed by Ray.

hello it is in category sdk\DataType\DataTypePicComp3Unsigned.

and it says that this routine is used for
Converts an unsigned packed decimal number into an integer.

can you please elaborate more on this ArndW.

Hello have you tried to execute your procedure from command line. i think you have an issue with procedure.

please check, if it not the case then we need to check for something else .....

thank you ray !!

from your description it seems that your proecdure does not need input nor it is giving output. so in your procedure stage just give the name of procedure in tab SYNTAX(Procdure Name) and select Procedure type (Transform). hope it may help any issues please paste your error message for us to guide y...

hello ray please can you please elaborate on it, in my case i have selected OCI stage --> Input tab-->General tab-->(Update existing rows only), but in SQL tab it still shows both of the tabs as disabled.

i have checked for selection like User defined SQL also.

yes just like you call any program from job properties, before-job subroutine or after-job subroutine tabs.

just to give an example

ExecDos sqlplus -s oracle/oracle@BIODS.WORLD @#directory#\in\1.sql

similary you can work on pro *c file execution.

i think these tabs are always disabled.

something like this

Deffun COMNettoieFichier(A1, A2) Calling "DSU.COMNettoieFichier"

i have worked with call a .sql file from after job routine which is in JOB Properties, General tab. in after job subroutine drop down select ExecDos and next to is is Input value where you can type or call your .sql file which in turns calls a oracle procedure. just a example ExecDos sqlplus -s orac...

dear can you please elaborate on the sequence mentioned which confusing but after one job i have to execute this job, if we can analyze the sequence, you can get proper response.

i have a question like i will use a parameter (date parameter or string parameter) having a values like '31/01/2007' 'DD/MM/YYYY' FORMAT for my job, can i use this parameter in my OCI stage for comparision with columns containing date values.