DSXchange

Hi,
Congrats!!!!
well done.. great .. Brian!!!!!!!!

Hi,

In Filter Stage, assign keychange=1 in Where clause and map wanted columns to Output link and In option set Output Rejects = True that way you will be having rejects in reject link.

Thanks

Hi,

You might be able to find same topic by searching likt this viewtopic.php?t=103005&highlight=host+i ... 7ac91831bb

Thanks

Hi,
Is there any documents available for C-Guide( by IBM) like Basic Guide is available under "Ascential\DataStage751\Client\Docs"

Thanks

Hi, I Used other option to Do Update and then Insert (using User defined query) When I was doing the same in single ODBC Enterpeise Stage ( Write Method : Upsert, Update then Insert, Using user Defined query) then I was getting Fatal which I explained in earlier post. Now I did : From transformer, I...

Column Definition:


SUB_NM Varchar (50)
G_SK Integer (5)
EFF_DT Date(10)
EXP_DT Date(10)
C_CD Varchar (5)
A_SK Integer

Thanks

Thanks

Did you try ArndW's suggestion?

Yes

I want to Update and Insert both at one pass ( I mean 1st do some update to Target Table then Insert new Record)

Are you getting any sql codes along with your error message, including the warning messages?

No

Thanks a lot

Thanks

Have you tried just insert and just update?

Yes both are working.

Thanks

Append to above Post :

Or any other option to perform same logic I mean to perform Update and then insert.

Thanks

what is the column data type for that value?

It is Date.

What database are you connecting to

It is DB2

As I posted earlier: In Update SQL I am using data from Tranformer for Updating.
BUT
to Insert I am using this SQL so I am Hard coding it

Thanks

I am sorry
Actully I posted in earlier post
it is :

DataDirect][ODBC lib] Program type out of range

Thanks DSGuru2B, I tried as you said and found that Actully Insert Giving me Fatal: INSERT INTO Table_name ( SUB_NM, G_SK, EFF_DT,EXP_DT, C_CD, A_SK) VALUES ( ORCHESTRATE.SUB_NM, ORCHESTRATE.G_SK , CURRENT DATE, '9999-12-31', 'C', ORCHESTRATE.A_SK ) What is wrong with this ? All columns are there in...

No,
Sorry,It was pasting error

Thanks

Hi, I am using ODBD stage as Target Stage. I am doing Upsert Mode, Update and then Insert. Update Query: UPDATE Table_name SET EFF_DT = ORCHESTRATE.EFF_DT, EXP_DT = ORCHESTRATE.EXP_DT, C_CD = ORCHESTRATE.C_CD WHERE (Table_name.SUB_NM = ORCHESTRATE.SUB_NM) AND Insert Query : NSERT INTO Table_name ( S...

Hi
Try this one which Explain A to Z about how to read that Max value from flat file and pass that value as parameter to next Job in Sequence.

http://dsxchange.com/viewtopic.php?t=10 ... 17d6665f09[/url]