DSXchange

Why? Formatting is for peoples, no process you create this for will care. And you can always "pretty print" it yourself afterwards simply (one way) by opening it in something like IE. That's how the formatted output option in the stage works and looks - "turn it off" is my best ...

Hello While I am able to create a valid xml file sourced from a database table - i am not able to get the xml in the exact format required. For ex: if the following are source records Name Age Ad 1 Ak 2 I would like the output xml source code as <student> <Name> Ad</Name> <Age>1</Age> <Name> Ak</Nam...

Hi, Have looked up the forum regarding this issue and as far i believe the deletion of the logs of the instances created, as shown in director is a manual process. The problem is we have a common job which is being called at least twice in about 119 sequences being run daily/weekly/monthly. and dele...

I find it straight farwords SQFILE---->stored procedure------->file Keshav, stored procedure stage is available in Data Stage 7.5 so its ok for them but for prior versions we have call SP trough OCI or ODBC stage Thanks If you're not on a version lower than DS 7.5 you cud use the OCI stage for call...

I have tried that but still it logs warning. I have simplified the job sequence to just calling a routine but still it logs warning. We used to set the trigger to un-condition for routine activities, no matter what it returns we just want the return value to be picked up by a followed job activity ...

ErrCode = DSSetParam(hJob1, "SOURCE_FILE_NAME",Output) First things first - are you trying to set the value of the parameter for "this" job itself. If you're setting the parameter of a job that u wud be calling then ur code looks fine ... U cant set the parameter for the calling ...

There are XML plugins that come with the product...there is also the additional XML pack that u cud install - the pdf's are the best way to start.

From what you wrote - the XML stage should suffice but for more complex logic you could consider creating your own scripts

[The OPENSEQ will take the ELSE branch if the file does not exist, and you shouldn't be using the STOP statement in a subroutine; this is designed for use in normal BASIC programs, you could replace it with "ELSE TimeStampVal = ''". This is most likely the cause for your job control error...

Hi Have been sweating it out wothout much success over checking for the presence of a file and if present reading a record through the Job control. If CurrentStatus ='R' Then OPENSEQ '/home/adarsh/':SequenceName:'.txt' TO FILE THEN READSEQ LoadIdTimeStamp FROM FILE THEN TimeStampVal=Field(LoadIdTime...

DataStageCnu wrote:Hi,

Try some other way..

Delete table <---> where 1=1


Is it help you..??

Am sorry but dont u think that wud delete all the records!!!

So you could perform your delete if your job aborts, a sequence job trigger executes a delete/rollback job that gets passed the process id and table name as a parameter and removes the transactions from that table. Could be used for any table. Hi Could you tell me what the pid would help me doing -...

The c++ compiler license limits the number of concurrent compiles that you can do; if you try to exceed this limit the warnings that you are seeing are issued. This is only a warning message; perhaps the error about inability to find a license is just an artefact. Hi I agree that the "1540-521...

Thanks guys I'm using the JobPID value returned, in addition to a timedate() value and it works pretty fine over the initial tests done - I'm not quite sure about usinfg the RND() function coz i agree that unless u seed it with a inherently unique value - the ouput will not be guaranteed unique - th...

How about using the system time as the invocation ID, or some other value. Hi We're calling a common job (multiple instance toggled on) from a routine which may be called parallely My doubt is even if do use the time returned by a timedate() function, it does not guarantee uniqueness of invocation ...

Geez thanks - I modified the logic to use the parameter values of the last run and it worked fine.