DSXchange

I test the routine in the UAT project and then copied the SDKSequences and D_SDKSequences files from DEV to UAT.

It worked. Thanks.

I need to migrate SDKSequences from my Development server to UAT server. My servers are in Sun Solaris.

How to do it? Please let me know.

Thanks.

Hi, I have created a sequence to run three jobs. If any of the jobs finished with status other than OK then my sequence aborts. The problem: If any job finished with warnings, it will abort the sequence. If I re-start the sequence the job which finished with warnings gets skipped. Any idea how to av...

I have used the third option with full path but it was not working because I was only testing using viewdata.

Then I remember that viewdata will not work here. It will only read in runtime.

Thanks Craig, its working now.

I tried using:

FILE='FILENAME.SQL'

OR

'FILE=FILENAME.SQL'

OR

FILE=FILENAME.SQL

Still not working.

I am getting the error: NW_EPM_GLW_FTF_F_NW_DOLLAR_C_VW_FOOTER..Dynamic_RDBMS_61: ORA-00903: invalid table name DSTAGE-DRS-0122`:`Token 'FILE=' is required for specifying User-defined SQL file NW_EPM_GLW_FTF_F_NW_DOLLAR_C_VW_FOOTER..D ynamic_RDBMS_61.DSLink1: DSP.Open GCI $DSP.Open error -100. How t...

I need to call a user defined sql file from DRS stage. This SQL file will have "select" statement.

I tried the DRS stage to call user-defined SQL ,but its not working.

If anybody knows the exact way to call user defined sql file then it will be great.

Thanks.

I receive data from 3 files and I need to Funnel them and load it to a table.

In parallel job it could have been done by Funnel stage.

I am using server job. Please let me know how it can be done in server job.

*Note: Moved to correct forum - Content Editor *

Is there any way to do the oracle date functions listed below in PX transformer?

add_days()
add_months()

Please let me know.

Thanks.