DSXchange

HariK

suryadev wrote:"APT_0_comm_type" in transfer from "inRec" to "outRec"

Try running the job after deactivating the RCP option.

HariK

chulett wrote:Soundex is Soundex and really should behave identically across platforms. Have you found that not to be the case? :?

My Bad. The function is based on the standard, open algorithm for SOUNDEX evaluation

HariK

Javieregh wrote:and Soundex function ??

There is soundex function, but it does not behave same as the SQL funtion. search Soundex on help available on Datastage Designer

HariK

Javieregh wrote:index(table.column,'XXX',0) Is this syntax ???

Thanks

index(table.column,'XXX',1)

HariK

Javieregh wrote:Eg:- table.column like '%XXXX%'

index function in transformer stage.
Or
Filter stage supports Like

HariK

markgeorgefath wrote: if we schedule a job to run as a one off we are unable to view it on the schedule.

If the job has started executing then the schedule will be cleared. If the job has not started yet you can definitely view it.

HariK

Code: Select all

 TABLE.SDATE >= TO_TIMESTAMP( CONCAT( ( TO_CHAR( SYSDATE  , 'YYYY'  ) - 2 )  , '-01-01 00:00:00'  )  , 'YYYY-MM-DD HH24:MI:SS'  )

Could you try the following, to check if whether Edit 1 has the issue.

Code: Select all

 TABLE.SDATE >= ADD_MONTHS(TRUNC( SYSDATE, 'YEAR') , - 24)

HariK

What are you doing with all the data that has been extracted? post more information about the job design.

HariK

jpraveen wrote:can we write multiple SQLs in a single CLOSE COMMAND

I have not tried in parallel, but think you can. The same works in Server After SQL.

HariK

Have you checked the OS variables PATH, LD_LIBRARY_PATH?

HariK

You can execute SQL Server Stored procedure using ODBC stage. Not sure though about row by row execution.

HariK

Assuming the problem is with reutrn type. In function it is Boolean, in DS job it is Varchar. Not sure if Boolean is supported in DS 7 version for Oracle.

HariK

Do a search for 'DataStage Analysis' and most probably you would get what you are looking for.

HariK

export from prod1 , import in prod2?

HariK

agpt wrote:Thanks for the info Gaurav. But looking for some more robust solution if possible as we have millions of records.

is anybody else have done it in some other way?

Merge or Join can be used in place of Lookup if volume is the only concern.

DSXchange

Search found 68 matches

Re: Funnel warning

Re: Function Like and Soundex

Re: Function Like and Soundex

Re: Viewing One Off Scheduled Job

Re: Editing an Oracle WHERE clause

Re: performance problem in 8.1 server job

Re: CLOSE COMMAND

Re: DB2 Plugin metadata not able to access

Re: Stored Procedure issue