DSXchange

You need to understand that not all FTP is just FTP. The FTP stage doesn't simply transfer the file as bytes like you'd get from the command line but rather it uses the FTP protocol to read the file, line by line. And that means it functions much like the Sequential File stage - it is totally metada...

If you have 8.1.x, where are you carrying the logs - in the traditional Project location or in the XMETA database? Are your logs... large? I'd also be curious if your &PH& directory has a large number of files in it and if this happens with all jobs or if this is specific to this one sequence.

No, it doesn't sound like you've even gotten to a point where the number of columns would matter, never mind the fact that the number of colums shouldn't really matter. How about a big picture, an overview of what you are doing. Tell us exactly how you are attempting to ftp this file - command line,...

You need to have checked from within a running job, not from the command line - did you? This could also be a 32bit addressing limit.

Once you figure that out, please re-post your question in the appropriate forum. This isn't it.

I am not sure if this has anything to do with Fix Patch 1 for Version 8.1 that we applied recently. Hmmm... very interesting. Anyone know for certain? Not to sound too complacent, but more to be of help to other visiting this post. This stuff really works and the code is in Production Complacent? :...

this is not about the proc itself So actually this *is* about the proc itself. And we have to ask 'basic questions' when people don't supply relevant details, especially considering how often the answer comes from those kind of questions. If your proc is returning multiple records from your cursor(...

What would you do to 'join' these two tables outside of DataStage, say in your favorite SQL tool? Once you determine that, do the same thing in DataStage.

I'd also confirm that you are connecting to the proper instance in the ODBC stage, make sure it's the same one that you tested this with via sqlplus.

Hmmm... 18 minutes? Not bad! Shreya, in all seriousness, you need to ask questions here rather than drop a requirement into a post and expect to come back to a solution like we're doing laundry or something. :? DataStage jobs always run 'as a background process' so you'd have to clarify what you mea...

The Stored Procedure stage IS available, someone there may have chosen to not install it however. And no, never heard of nor seen such a thing when you 'fully qualify' the proc name, expecially considering it has no input parameters to get wrong.

jinm wrote:Instead of raising a new topic I just takes this one hostage...

Bad idea. I've moved your takeover attempt to its own topic.

Post the syntax you are using to call it and confirm you have the Job Parameter defined properly in the Sequence job that uses the Routine Activity.

Please post examples of the actual 'formatted' data you are trying to load to the Timestamp and Decimal fields, plus your user-defined sql. And you are targetting DATE or TIMESTAMP fields in the table with your Timestamp data?

OK, start back at the beginning. What exactly are you doing in the OE stage: settings, action, etc etc? Any non Varchar fields involved?