DSXchange

hi,
Why do we need the
DEFFUN function in this case?
You get the same results in the routine without
DEFFUN ConvertMonth(X1, X2) CALLING "DSX.CONVERT.MONTH"
this statement?

Ketfos

Hi
REJECTED Can be used in the constraint expression of a Transformer stage of an output link. REJECTED is initially TRUE, but is set to FALSE whenever an output link is successfully written.


?What does value 0 and 1 represent in above case?

Ketfos

Lets assume 1. Its flat file on UNIX having 10 fixed width columns with Oracle table as target on Unix. 2. It sorts on one field 3. there are no conditional derivations in transformer or custom fucntions. 4. It truncates before loading. 5. there is no Referential Integrity involved. Can we still hav...

Why not make use of Transform - RowProcRunningTotal (available in Category - sdk\RowProc)
It returns running total of input values.

ketfos

If this is the case, Ascential should treat this as bug in the product. Why would then somebody ever user Arrya Size more than 1 This is what the DataStage help reads- The number of rows written to or read from the database at a time. Input. The number of rows to be transferred in one call between D...

Thks
The Array Size was set to 500.
I changed it to 1
It worked and wrote the correct record in the Reject link.

Ketfos

Q. How does this makes difference?

Hi, Job reads input sequential file (52982 records). The output is Oracle table. All fields in the target are varchar except one field(number) In the transformer I have two outputs - one writing to a Oracle table and second is a Reject link. I check Reject Row check box in constraints and also add a...

Hi,
You can issue truncte table command in SQL After tab in OCI Stage or
In the Job Properties, you can issue a sql statement in the After Job Routine.

Ketfos

Hi, There is a file dsenv which sets up envirornmental variables for datastage. By default it is set in dshome/DSEngine directory but can be in a different path. You can read this as seqential file in a datastage job and find out different environmental variables set like DS_MMAPPATH=/tmp; export DS...

Hi,
Try this
OCONV(@DATE, "D-YMD[4,2,2]")

1. @DATE system variable - The internal date when the program started
It return integer value.

2. When this is passed to OCONV it returns the date as 2004-06-09

Ketfos

What exactly do you need ? What is your specific requirement/task you want to achieve?

Ketfos

Hi,
What are two type of input sources you have?
What type of targe(s) you have?
What are you doing in tranform state.

Ketfos

Hi,
Can you send your user defined sql?

Ketfos

Hi, You may do addtional check to find the missing record. 1. Try using @OUTROWNUM System variable in the transformer while writing in the sequential file. This is incremental number and will give you record count in the output seq file. 2. Try using another link in the transformer which will write ...

Hi Raj, This is what I mentioned earlier ------------------ Hi, You are having one source table(TBL A). Your job will have two outputs from a transformer. LinK A will have table with output UPDATE ACTION AS 'UPDATE EXISTING ROWS AND INSERT NEW ROWS' Link B will have INSERT ROWS into another table WI...