DSXchange

Yes... did you check the Help?

InputField isn't a function but a generic field name used in the example. And the square brackets *are* the substring operators in both PX and Server jobs. You couldn't find the 'date component' functions Ray mentioned? He meant Appendix B, at least that holds the Functions in my 7.5.1A version: Mo...

The DIGITS transform is what you seek, more than likely. Which is just an interlude to OConv, but is easier to understand. And I think the Help gets a bum rap in that regard - search the Index for 'BASIC tasks' where they know you might not know the exact function you are looking for but assume you ...

Did you try any of the options given to see what happens? Verified that indeed they are not an option?

Ok... now you need to post your ftp command file: the ftpscript.txt file.

Does your employer or client know you are installing the software on your *home* computer? That is usually highly frowned upon.

There is no log 'file'. The logs are hashed files in the job's Project, named with the internal job number: RT_LOG1234 for example. Your requirement does not have a simple or short answer. How are you planning on implementing this - in BASIC as a routine of some sort or via a scripted approach? Both...

That would be a PX answer not applicable to a Server job, please keep an eye on the forum you are in and to the Job Type. No can do. Oracle will only report one error at a time even if you have a multiple problems. That's just the way it works. Unless I've misunderstood what you meant by 'first occu...

I don't use the stage and don't have problems scripting ftp sessions under UNIX, so can't really help you there. The FTP stage *is* metadata driven, but there is an option to say 'Check data against meta data: No' and to set the Data representation type to 'binary'... have you tried those? With perh...

Why not store your timestamp as separate pieces as well? Then you could use something like:

DATE > DATE or (DATE = DATE and TIME > TIME)

Not elegant but would work.

What 'batch log'? Sounds like you may need to write an after-job routine to get a LinkRowCount and write to your 'log file' if the value is > 0.

A) ETLStats. Say 'Thank you Mr Kim.'

B) See A.

I registered Monday. Will be great to see The Gang again.

Let's not also forget: 1057 Macbeth, the King of Scotland, was slain by the son of King Duncan. 1769 Napoleon Bonaparte was born on the island of Corsica. 1935 Humorist Will Rogers and aviator Wiley Post were killed when their airplane crashed near Point Barrow, Alaska. 1939 The MGM musical "The Wiz...

Meaning what, exactly?