DSXchange

It's always wanted it exactly like it is on the paper. So the date may actually be 01/01/2500 (leading zero). The authorization code itself is always eleven characters long. On the paper they print numeric characters in italic, so you can differentiate between lower case "L" and the figure 1, and be...

It's all completely different in Hawk. You don't (can't?) access the repository directly; instead you rely upon calls to a "metadata delivery service". However, I see no reason to believe the rumour. The way that server jobs run still has to support DataStage BASIC, and there is no reason to believe...

NLS_LANG is an environment variable that can be set in the executing user's .profile file, or in the dsenv script for DataStage processes.

Search the forum (or the manuals) for dsjob (the command line interface) which your Windows scheduler can use to invoke a DataStage job when arrival of a file is detected.

Read about it as FORMAT.CONV in the UniVerse User Reference page 1-191 and following.

Then, quite simply, the value of the DATE_JOUR must also be in the same format. You will also need to convert both to date or both to string if necessary so that the comparison will be valid.

Surely "exeunt omnes" ?

Separate exports per project is the only possible strategy with either tool.

InputArg contains the contents of the Input Values field. This could be a space separated list of file pathnames. Parse these within the subroutine using the Field() function.

My guess is that the file system on which your project directory resides is, or has been, full. This has caused some of the Repository tables to become corrupted. Open your Administrator client and issue the query SELECT * FROM RT_CONFIG2646; in the Command window for your project, and post the resu...

No, if what you have in mind is, for example, restore from system backup onto new system. The problem is that there is a lot of information in system tables that is not updated by this method. There is a "UniVerse" utility for exporting a project so that it can be rebuilt, called format.conv (it als...

As in "exit, stage left, pursued by a bear" ?

You want to rewrite the mv command in a before/after subroutine? OK, it can be done. Why not make an attempt? Then we'll guide you if you can't get it to work. Specification 1 Open the parent directory using OpenPath. Generate CNAME commands and execute these through DSExecute(). Close the directory...

Then your logic needs work.

Try creating a specification in English of how column D is to be derived in English. This is often useful as a mind-clearing, or at least mind-focussing, exercise. Post the specification here and we may be able to target assistance more accurately.

I'm forced to assume that "Orchastrate" misspelled is a result of your not using copy/paste. Get your Oracle DBA to intercept the command to see exactly what statement was executed. If all else fails, join your data stream to the target table to make sure you get all the relevant rows updated; you m...