DSXchange

Hi,
You can go through the in-built routines first and understand what is the purpose of the routines and what is the Syntax.

Then you can start creating simple routines does some date or string manipulations.

So, You can Resolve the issue.

Hi,
As suggested above start with examining the score dumps.

Add the Environment Variable APT_DUMP_SCORE to your job and set this to TRUE. Observe the job log for details.

Then do a search in this forum as Ray mentioned.

Hi Karthik,

One more Option to what is mentioned above:-
You can write a server routine and call it in after job Subroutine.
Here you can also specify to execute it only of the job finishes successfully.

A-->ord1 B-->ord1, ord2 C-->ord1, ord2, ord3, ord4, ord5 Yamini Hi Yamini, You can post such Questions in General forum. Anyways, since the number of orders for each vendor is not 'fixed', you can have a generic table like VENDOR_NAME | ORDER_NAME | ORDER_DETAIL A | Ord1 | Order1 B | Ord1 | Order1 ...

status varchar completed_date timestamp the column status will have value as 'S' and 'C'. i want to pick the maximum date from the completed_date column with status as 'C' and load it in the target file. the time is displayed as 'yyyy-mm-dd hh:mm:ss.000' Hi, You can try this:- Before passing to agg...

If lookup retuns multiple records i need to reject the source record. Hi, If your lookup is a table, you can write the lookup query in this way:- 1) Group by the columns that you are going to use as lookup keys 2) obtain the count also along with the other required values 3) add a 'Having' clause w...

Warning1:APT_CombinedOperatorController(1),3: Conversion error calling conversion routine timestamp_from_string data may have been lost. Warning2:Lookup: Input dataset 1 has a partitioning method other than entire specified; disabling memory sharing. Lookup,2: Ignoring duplicate entry at table reco...

I am using dsexportcmd.exe to export. Hi, Iam not sure about the syntax and options to specify for dsexportcmd.exe. But check if you can export 'job executables' and 'program sources' along with the job design. Also, if any transforms, routines are used in that job, you need to include them too. DS...

Hi, As far as I can say, It is always better to match the primary key in the database and the keys defined in Oracle stage. The keys that we mention in the Oracle Enterprise stage will form the basis for an insert / update action done by datastage. If the keys dosent match, you might end up having d...

http://dsxchange.com/viewtopic.php?t=12 ... 12b3664454

http://dsxchange.com/viewtopic.php?t=11 ... 12b3664454

No specific syntax I believe.

As the manual suggests, you can type in the delete command sql you want to run in the Open command option.
You should enclose the sql in single quotes.

Try and let us know.

From Manual:- " Open Command: This is an optional property and only appears for the Load Write Method. Use it to specify a command, in single quotes, to be parsed and executed by the Oracle database on all processing nodes before the Oracle table is opened. You can specify a job parameter if re...

Hi Sunitha,
Post the question in correct forum as Ray suggested.

We can defnitely help you resolve the issue.

*Note: Topic Relocated - Content Editor*

Hi,
One advice.
Instead of 2 jobs and a sequence, you can use the Open command Option in the Oracle Entreprise stage to delete the rows before inserting them.

There are lot of posts in this forum about Open Command Option.