DSXchange

Im posting it in the GEneral forum as Sequencers are 'General' by definition.. So Moderator - Please do not move it to server Forum :wink: ) Hey... if you've been following along since I've put on the Moderator's hat, you'd see I move all Sequence topics into the General forum if people post them e...

At least that one should be solvable via the proper NLS settings, I would think. Not sure how much control you'll have over that float field, however.

You mentioned "changing it" in a downstream transformer, can you let us know exactly what you tried - function(s), data type(s), etc?

Why not just stick with the RDBMS stage, seeing as how it works the way you'd like it to?

How are you planning on running any jobs against that database if there is no "select access from the DataStage server"? Surely you must have at least one id defined on the server for connectivity there - can you not use that for the metadata import?

Database... DB2?

Hence the initial suggestion, which was deemed to be not "automatic" enough.

Right, but in my experience many don't like the dashes in the date and would prefer simply "yyyymmdd". It gets worse if you want a full timestamp.

It would actually be "mv" rather than "rm" and the syntax would need both filenames mentioned. The macro can be ok but most people don't like the formatting that they come with.

Or you would need to insert into the base tables and it would refresh immediately or if set up deferred you would have to trigger the refresh.

Hmmm... not much there to go on. If you Reset the aborted job from the Director, does a log entry should up labelled "From previous run..."? If so, can you please post the contents of it.

That's as "automatic" as it gets. Another solution is to build a fixed filename than then rename it after job via the O/S to include the date.

An exact search for "OCI_INVALID_HANDLE" returned 23 other matches, did none of them help?

As noted, use a job parameter you include as part of the filename, wrapped in hash / pound signs like any other parameter is typically used.

If there are always 5, youshould just need the @FM convert on the last one:
Trim optional. And convert the Field Mark to an empty string rather than a comma.