DSXchange

Refresh the Repository Browser: View / Refresh, see if it shows then.

Ok, that wasn't so hard to figure out. Built a small testbed routine to check the conversions and found that it doesn't like the space in the time before the AM/PM part. Silly Wabbit.

Try this:

svTimestampTime: Convert(" ","",Field(src_out_C_CUST_MTCH.CREATE_DATE," ",2,99))

Sounds like you are using an ODBC stage. If all you did was change the Quote character, try pressing the Get SQLInfo button, recompile the job and see if that helps at all.

Well... there ya go. Your time transformation is failing for some reason. Now just need to puzzle out the why of it...

My initial response stands. Both of them, actually.

Which is (allegedly) exactly what he is doing. You should also create two more stage variables and add them to the diagnostic file. We know you are parsing the input string correctly but nothing else for certain. Do the conversions in the stage variables and just the concatenation in the final deriv...

Then you need to tune your query or bump up the arrary size in the ODBC stage. It should be able to write data as fast as you can pull it from your database and push it across the network.

That or you need the patches thompsonp mentioned. Or both.

Got nothing to do with ODBC, it's all about your database.

ORABULK is for Oracle 7, ORAOCIBL is for 8 (and up). Both are 'bulk loader' stage so use them (the latter, actually) when ever it is appropriate to bulk load the data.

Huh... there's no reason that I can see here why the techniques posted wouldn't work as this is pretty standard timestamp work. Can you repost (since it has been through some modifications) exactly how you are doing this now? Cut and paste from the job things like the stage variable derivations, the...

Krazykoolrohit wrote:What happened to the interview forum anyways?

Spambots ate it.

Seems like your problem has already been reported. Best if we stick to one thread per problem.

Any chance you've got the eCase numbers for those patches?

I'm sure they could, but... see if your SA can.

Guess I need to revisit that chapter. Usually I'm only there to visit with the 'dsjob' command. Thanks.