DSXchange

Engine status is obtained from the existence of the DataStage disk shared memory segment. This has a shared memory key of 0xadecnnnn where nnnn is the DataStage version number, for example 0xadec7511 where I'm currently working. The "ade" may be different on an -itag installation. You can use the ip...

You have to get this alert, since what you are doing could result in loss of infomation. You can not shoehorn a 31 digit number into a 15 digit number. Therefore DataStage will not let you suppress generation of this warning. In short, NO. I take it [15,6] or [15,2] is a typographical/transcription ...

NO, because I refuse to use RCP, because I believe in strict management of metadata. If "they" could figure out a way that lineage analysis could identify the source of data generated by RCP, I might be persuaded to reconsider. You are wrong to assert that RCP is needed to map a column, this is just...

It might be that you lack write permission to the parent directory and so can not modify the date/time modified and date/time accessed for the file that you have been writing.

That is not correct. If you include that column in your design, directly mapped to output, then RCP has no effect.

Since RCP can invalidate lineage analysis its use should be discouraged.

RCP is, in my view, only for lazy developers.

Or you can use the Oracle concatenate operator if you use user-defined SQL.

Or just process the job sequence's log filtering the "job run requested" messages.

Or capture the "summary of sequence run" event near the end of the log.

All too complex. To convert to an internal date all that is needed is

What don't you get? I pointed out that you can't violate the data type and nullability rules.

If you can't read my entire message because you haven't yet purchased premium membership, this can be corrected for less than $1 per week.

It could be done in an expression (or stage variables) without needing to go to a routine. Some combination of If..Then..Else (with MATCH operator), Field() and Oconv() functions (the latter with "MCA", "MC/A", "MCN" or "MC/N" conversions) should do it for you. The "magic bullet" function that you s...

... unless /tmp is very small, which it often is on Solaris especially (and they mount swap there also!)

Check the Schedule tab in Administrator to verify whether or not you really do run under the same ID for scheduled jobs.

chulett wrote:You can't transfer a file with the FTP stage? Isn't that what FTP stands for?

No, it stands for file transfer PROTOCOL, and transfers the CONTENTS of the file. The FTP stage receives/sends this data stream without touching down to disk.

Excellent post on HAWK Ray! With so much of confusion going with all the different product names floating around, and products renamed several times, it is all very clear now after reading ur post. One note on the HAWK posting i would like to make : the current HAWK BETA product we have installed o...

While it's true that you can't use an FTP stage for this (the data flow streams into or out of an FTP stage) you could create a shell script to execute the FTP command, and invoke that from DataStage - either from an Execute Command activity in a job sequence or from a before/after subroutine in a j...