DSXchange

Thank you Very Much...

I tried using four parameters in SP stage... P_PROCEDURE_NAME VARCHAR2(200); P_ACTION_TYPE VARCHAR2(200); P_ERROR VARCHAR2(200); P_USER VARCHAR2(200); After the changes, now I am getting the fatal error like... Stored_Procedure_0,0: Operator terminated abnormally: received signal SIGSEGV main_progra...

Hi, I have used Stored Procedure stage in parallel jobs to run the stored procedure "PR_PROCEDURE_LOG". Procedure name : PR_PROCEDURE_LOG ================================== CREATE OR REPLACE PROCEDURE GPM_STG_ETL.pr_procedure_log(p_procedure_name IN VARCHAR2, p_action_type IN VARCHAR2, p_e...

I have used "Expression Editor" in transformer to insert the job parameter .

:D THANK Yuuuu.... :D It's Working..... :D

As mentioned,I have used this pass job parameter in transformer. My jobparameter is $GLB_ETL_BATCH with Default value as ETLBATCH. However I am getting Job compile error as... Output from transformer compilation follows: ##I TFCN 000001 13:23:50(000) <main_program> Ascential DataStage(tm) Enterprise...

Job parameter values are available only at runtime...How to reference them in DS JOBS...?

I have to capture those parameters during runtime; i.e single run. And propagate those parameters from the source file or DB Stage to target.

I have to capture those parameters during runtime; i.e single run. And propagate those parameters from the source file or DB Stage to target.

Hi,

During runtime, Is there any way to capture job parameters and pass those job parameters from source file to Target file...?

Regards,
JIM

If I do the lookup with "Nullable No" to "Nullable yes" column,
Job was aborted ...So I tried with modify stage to convert this Nullable NO to Nullable YES.

Regard,
jim

My job is like ... (PLANT_IDENT_CD) Nullable No Plt_idt_cd----------- Lkup-------------------->Transformer---->OracleEnt (Nullable Yes) From lookup ,I have to convert this PLANT_IDENT_CD to Nullable 'YES' and later it is passed to transformer. When I try change this column to Nullable 'Yes', this is...

Yes I tried with modify stage and I am getting following error... Modify_506: When checking operator: When binding output schema variable "outRec": When binding output interface field "PLANT_IDENT_CD" to field "PLANT_IDENT_CD": Null value handling is specified with a no...

Hi,

I have 4 column's which is of Nullable "NO", Is there any way to change this to Nullable "YES"...?

Regards,
JIM