DSXchange

Ok here is the update. I am running the following code: OCONV(ICONV(Exp_Stg_Load.VDATE, "D-YMD[4,2,2,]"), "D4-MDY[2,2,4]") : " " : oconv(00:00:00, "MTS") getting the following error from the Director: EXP1LoadStgTbl..Transformer_115: [IBM][CLI Driver][DB2/NT] ...

AGGGGGGGG not haveing a good day. So what Im doing is wrong obviously. Can any one tell me what formate DB2 wants to see a timestamp in so that I can formate it in that way. I have looked at the data and what I see is aparently something that DB2 displays but not what it actualy stores. Any help wou...

ogmios wrote:Are you using an ODBC stage or a DB2 stage to connect to your target?
Is you're source an ODBC stage or a DB2 stage?

Ogmios

Im using the db2 stage and my source is a sequencial file
Jim

I am haveing the worst time formating a date to go into my DB2 UDB server. This is a date out of the server: Aug 21, 2003 2:13:44 PM This is what Im outputing in DS: Mar 01 2004 00:00:00 using the dirivation OCONV(ICONV(Exp_Stg_Load.VDATE, "D-YMD[4,2,2,]"), "DMDY[A3,2,4,]") :&quo...

Looks like it was a meta data mismatch. Always remeber to look at your meta data
Jim

I am getting the following error Transformer_8: OLE DB provider error: The statement has been terminated. my job consits of a sequential file feeding to a transformer going to a SQL server bulk loader. The job worked fine last month. The only change is that I had to add a column to the data source a...

Jim The issue is that to rebuild an index you need exclusive use of a file. The delete index works fine so it looks like you have no jobs. They are there but indexes are not usable. If you do a LIST.INDEX then you can see that they were not built yet. DS.TOOLS was meant to be used only by dsadm wit...

I reran the index rebuild and got my jobs back
Jim

Ok now im in panic mode. I rebuit my repository indces becase i had a job locked and after i tried to unlock them it was still locked. Now i cant see any of my jobs!!!! I know they are still there because when i tried to do a reimport it asked if i wanted to over write. i didnt overwrite but how do ...

I have a job that bulk loads to a SQL server. The flat file is 8 million + rows. If i do this through SQL server it takes 20 mins. In DS its taken 14 Hours!!!! Why is it taking soo long to do this?
Jim

chulett wrote:Next thing ya know, you'll have circles around your trash can again!

OH REALY!!!!! I CANT WAIT!!!!!!


Jim

Wow get stuck in the snow and your thread goes crazy. I did learn some good stuff about custom trigers though
thanks for all the imput
Jim

Put in a Seqencer stage between the two job activity stages. Have 2 links from the 1st job activity to the sequencer stage, 1 for OK, 1 for warnings and have the output trigger from the sequencer stage set to ANY to fire the 2nd job. This way it will execute the 2nd job if the 1st job finishes with...

raju_chvr wrote:Have the same Job Asvtivity as another stage and the configure that Link to be triggered as 'Warning - (Conditional)' where as the previous one as 'OK - (Conditional)'

Well that makes sence.
Jim

Hi, No it will not continue if your only trigger is "OK" from a job activity - that denotes that the job activity completed without warnings. If you want your downstream link to fire if the job activity completes "OK" or "with warnings" then have 2 triggers from the jo...