DSXchange

Hi every one, i am calling one oracle stored procedure from stored procedure stage using datastage job. In my stored procedure i have two parameter first parameter , i need to pass VALUE 'Y' BASSED on the first parameter the stored procedure will fetch records from a table and doing some business lo...

Hi,

all datastage jobs are scheduled using control m. i want to get the each control m group completion time . how can i get it , i want to do automatic process , is it possible throw datastage can i access this control m log file?

can any one have idea about this,

thanks

kalpna wrote:Hi! Veni
what is ur requirement??
is that a record or column??(001,002,003)

Kalpna

001,002,003 is record...! based on tag invoice tag should go to target as first recod , child tag Invoice_item should go to second record .
Accounting_row that will go as Third records

Hi , this is my xml file i didn't give complete file , <?xml version="1.0" encoding="UTF-8"?> <SEND_SUPPLIER_INVOICE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="urn:ifsworld-com:schemas:send_supplier_invoice"> <DATA_AREA> <INVOICE> <invoice no...

HI I tried this way , but this also giving error - DSBINDIR='/opt/tools/datastage7/Ascential/DataStage/DSEngine/bin' ${DSBINDIR}/dsjob -run -mode NORMAL -param '$prmfilepath'='/data/dw/af2/rawdata/Strategyware060112.txt' -warn $WARN_LIMIT -jobstatus Error is - ld.so.1: /opt/tools/datastage7/Ascentia...

Hi All Where do i need to place my Unix shell script .Is it under Project folder ? Actually i am getting folowing while using - ${DSBINDIR}/dsjob -run -mode NORMAL -param '$prmfilepath'='/data/dw/af2/rawdata/Strategyware060112.txt' -warn $WARN_LIMIT -jobstatus $PROJ $JOB Error is - StrategyWareLoad....

Where do i need to place my Unix shell script .Is it under Project folder ? Actually i am getting folowing while using - ${DSBINDIR}/dsjob -run -mode NORMAL -param '$prmfilepath'='/data/dw/af2/rawdata/Strategyware060112.txt' -warn $WARN_LIMIT -jobstatus $PROJ $JOB Error is - StrategyWareLoad.sh[30]:...

I don't use the stage, but have you tried it with the parameter name enclosed in the standard pound/hash signs? :? Procedure call syntax "BEGIN test(#TableName#); END;" As long as TableName is a job parameter, that is. when i used "BEGIN test(#TableName#); END;" I got below erro...

How to pass parameter value dynamically to Stroed Procedure stage. for example i have one stored procedure called test(tablename) here Tablename is dynamically assigned by the job based on the Tablename parameter value Test procedure will extract data from respective table. ProceureName -' "EDW...

Hi all,

how to call build in procedure from oracle oci stage , i want to run following pl/sql code from oci stage

begin DBMS_MVIEW.REFRESH('Test_VW'); end;

Thanks
rv

I will call the unix script using the PERL job and internally unix script will call the DataStage job.

can i call this command inside my unix script or do i need to inclide any library for that (`dsjob -server ....` )

Hi

Is any one help me how to call DataStage job using PERL in unix server.

Will appreciate if any one can provide the code for calling datastage job.

Thanks in advance

Hi

Is any one help me in knowing where the OCI Bulk loader store the control and data file when we are using automatic option.

I wants to know the path of control and data file.

Thanks in advance

How to convert date to julian date format in datastage

in coming date format is mm/dd/yyyy , i want to convert this date to julian date format.

You could also use an Execute Command activity and use the test command. Again, supply two triggers, driven by the exit status of the command. There may be another advantage to using the test command: we found that WaitForFile requres read permission on the file. That could be a problem if the proc...