DSXchange

Not obvious but possible. You first need a query to determine which jobs are in a particular folder, then construct a looping script based on this list to run the jobs. If you already have the list of jobs, then the list can be hard coded. Row counts can be had from the -stageinfo option of dsjob, i...

If you find IADB cryptic you ain't looked at XMETA yet!!!

Have a DataStage Administrator check your DataStage roles. If you only have Operator or Super Operator role you will not be able to compile.

Those uvconfig entries aren't in place if NLS is not installed. Enabled is, of course, a different question, answered by checking the current value of NLSMODE.

The expression you mentioned seems to be relying on the ordinal position of the day in the week, that is day #4. You can generate expressions that return the day name (Oconv(@DATE,"DWA")) or day name abbreviation (Oconv(@DATE,"DWB")) or day number in week (Oconv(@DATE, "DD&q...

Are you the first to compile this job in this project? What permissions do you have to the project directory? What permissions do you have to the object named in the error message on the engine?

suryadev wrote:I am using 8.0.1 so I guess there is no manager....

There IS an Information Server Manager. It's a separate client, and has its own command line interface (istool).

I don't believe that's the case - my understanding is that the data samples and some intermediate results are in IADB, but that the analysis results themselves are in tables in XMETA. Of course the exception records themselves would be in IADB. Perhaps you could create a DataStage job to move them.

Not "the" compute node, but "a" compute node - there may be more than one, and it's a node on which computation takes place - that is, on which a player process executes.

WHAT "legacy stage"? What folder is it in?

There's no guarantee that what you want is in the DS_JOBS table - it may be in a table in the unified metadata repository (the XMETA database).

However, if you feel that you really must query the DS_JOBS table you can use the Administrator client's Command window.

Data Sets will still be written to the resource disk(s) specified in the configuration file being used by the Data Set stage. Ordinarily this will be the configuration file whose pathname is given by the value of the APT_CONFIG_FILE environment variable, irrespective of whether you specify sequentia...

laknar wrote:Set this Property on Format Tab of the Sequential File Stage.

Code: Select all

Null field value=''

Not in a fixed-width field, where the Null Field Value property must have the correct number of characters.

Changing entries in uvconfig has no effect until you issue a uvregen command and restart the services. In the meantime, set up before-stage subroutine and after-stage subroutine in your Transformer stage. Each executes ExecTCL. In the field for the command enter: SET.LOCALE FR-FRENCH in the before-s...