DSXchange

Hi All, I've a little problem with the UtilityRunJob routine. It works fine when I use it from a transformer of a server job, but it doesn't work in the transformer of a parallel one (I'm new to DS Enterprise Edition). I read here in some posts that it can be used both in server than in parallel job...

Perfect, thanks a lot for your suggestion. :D

Regards,

Ale.

Thanks Ray, I didn't know the concept of balck hole in OS', .\NUL works perfectly. Just related to this argument, I tried also to trigger off an ODBC stage from a seq file pointing to .\NUL, because sometimes I faced the necessity to execute a sql dml "stand alone" (an update or a delete w...

asitagrawal wrote:Possibly..what Ray is suggesting is ..to dump a NULL into the seq file...anyhow you mentioned that the file is being deleted at the end ...so whats the worry ?

No worries, only curiosity

Ray has pointed out correctly that the command stage executes a Command not a DataStage routine... Also, I wonder if we can have a design, where there is an Input Stage, a transformer , BUT no output !! (This, I am saying, becuase the seq file in your current design is being considered as Superfluo...

Hi asitagrawal, Thanks for your suggestion but my aim is to avoid using a support file. Actually I make in this way: odbc-stage -----> transformer ----> sequential file In a derivation of the transformer I pass the result of my query through a transform function that set the user status, than I save...

@ray I read in other posts that it's not possible to call DSSetUserStatus directly into a ExecTCL. I Tried in fact to embedding it firstly into a routine of type "transform function" and secondly into a transform function but in both cases I get the above reported errors. I read also that ...

Hi All, I have to set a value selected from the database into the user status. I retrieve the value (a single value) from an odbc stage, via a query on sql server 2k5. I need to make this value available to all the sequencer this job belong to, so I thought to put it into the user status via the fun...

Hi Ray, it seems that the restart solves the problem (sometime our test server degrade in performaces..). Is it a good practice to delete pointers after their use? (The pointers created will be useful only to this job and this process will run monthly.) My doubt is that a continuous deletion/inserti...

The problem is not on the name of the pointer, sometimes it runs and sometimes no (both mine and your version)..
I've asked for a restart of the datastage server, let's see if it solves the problem

Hi All, I've a strange error with a simple job. In a before stage subroutine of a transformer I define a VOC pointer in this way: SETFILE #$aDirHashedFiles#\HF_CIM_CD HF_CIM_CD_REF OVERWRITING The pointer is used in an universe stage linked to that transformer. If I run the job stand alone, it runs ...

Yes, I do. I build my statement as follow. Output Columns: - OFFICE_CODE , key, not null, integer - BRANCH_CODE , key, not null, integer - OFFICE_BRANCH_SURR_CODE, not null, integer And the reference sql statement is: SELECT office_code, NULL as tempField, office_surrogate_code FROM office_pointer W...

Try SELECT code, surrogate_code FROM ( SELECT branch_code AS code, max(branch_surrogate_code) AS surrogate_code FROM branch_pointer UNION ALL SELECT office_code AS code, max(office_surrogate_code) AS surrogate_code FROM office_pointer ) AS T WHERE code = ?; I get the same error (Table "("...

The errors I get from the statements I posted are: SQLSTATE=S0002, DBMS.CODE=950390 [DataStage][SQL Client][UNIVERSE]DataStage/SQL: Table "(" does not exist. SQLSTATE=S1000, DBMS.CODE=950125 [DataStage][SQL Client][UNIVERSE]DataStage/SQL: QUESTIONMARK not supported in TCL. This second one ...

Hi Craig, you're right, I tried to simplify my question in my first post. The situation is the following one. My stream is a sequential file containing some economical data regarding branches or other kind of offices. The fields: - a code identifying the single branch or office - other values not re...