DSXchange

In DataStage command language execute the following command from administrator after ensuring all users have been disconnected CLEAR.FILE &PH& In Unix, go to the project directory change to the &PH& subdirectory, and delete files Once again ensure all users have been disconnected fro...

Instead of terminator activity, you can use exec command activity to call the "dsjob -stop PROJECT JOB" command You can also refer this post You should create a wrapper sequencer that does " ResetIf required Then run " on the sequencer you are trying to run. A stopped or aborted ...

saith ray There is an error in the Parallel Job Developer's Guide in the Modify stage chapter. The name of the function that handles null values is incorrectly given as NullToValue(), which is the Transformer stage's function. In a Modify stage the function you need to use is handle_null(). Thats on...

Types 2 through 18 are static hashed files each based on the hashing algorithm / nature of key column data Type 30 Dynamic hashed file, where system decides whats best. And you have non hashed files Type 1,Type 19 (engine native files) Type 25(Balanced Tree) Type 27( Distributed or partitioned?? :? ...

Consider Payments as Donations to the Church of DSXchange???

I have seen quite a few posts , where the poster (usually a charter member) has plagiarised premium posts and made a few quick points in the process :roll: ? Is it not in violation of the spirit of the forum? rather than plagiarise, i suggest members to post the link to a premium post directly rathe...

A key field in a hashed file cannot be populated with Nulls unless you want a warning message in your log . Hence you need to check the key column for nulls before loading the hashed file.( Maybe using a transformer stage prior to hashed file, and using the function IsNull() to derive a constraint e...

here goes: 487160*WES

Moderator: Can This be moved to an appropriate forum? Private Messages arent meant for Public Consumption .

Craig Asked Cool, an Ecase to protect you from stray semi-colons? Let us know how that works out. Yes The Ecase has been solved.In the DSD_BP.O directory on the server project home pathname, we replaced the file "DSD_SEQOpen.B", with a new 'copy' IBM gave us. Funny That. Sorry for the rat...

If you refer the plug-in installation and configuration guide, under the plug ins documentation, you see that the Command Stage is available only for Windows platform and only for server jobs. Refer Page 35, Table 11 of instconf.pdf and Page 9, Table 1 of instconf.pdf. Any specific reason that you n...

Oops, Sorry for hijacking the thread, but will Hawk turn Hashed files into an extinct species? What happens to the underlying UV engine in Hawk?

Oh Thanks The command executed succesfully. Never thought on the lines of the semi-colon though. :) . HistoryUpdaterExtract..AfterJob (ExecTCL): Executed command: UPDATE SOIRecordCountHash SET SOIRecordCount = 0 WHERE DUMMY=1; *** Output from UniVerse command was: *** DataStage/SQL: 1 record updated.

I found quite a lot of forum threads on the DS 390 jobs posted in various categories.

Why NO Seperate Forum for DS 390 Jobs? Or is theJob Type mandatory field deemed sufficient to contain this information?

Thanks
Ramesh

As far as i know , the PX Transformer stage implements a C/C++ like sub Routine. While compiling a job containing PX Transformer stage , the job compiler searches for the Operating System c/c++ compiler in the location pointed to by APT_COMPILER environment variable. Setting correct values of the en...