DSXchange

Hi We are using the restartability feature in our sequences However since we fetching the parameters a control table to pass on to subsequent sequence - the values between an abort and rerun dont necessarily match, as a result of which the following warning message crops up JobControl (@Coordinator)...

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...

Hi We've been experiencing a nagging problem with our DS EE setup We have been seeing the following fatal error cropping up intermittently and causing the jobs to abort - ##E TCOS 000003 05:01:25(007) <main_program> Licensing error: could not find a valid license. ##I TFSC 000001 05:01:25(008) <main...

Windows XP - Home or Professional? And there *is* a patch to make DataStage compliant with the changes in Service Pack 2 - have you downloaded and tried that? You can find it on Ascential's eServices website. Thanks - Description: This patch resolves an issue with the DataStage Client when designin...

Hi Salil

Our Client Workstations are Windows XP Ver 2002 with Service Pack 2
The Install docs dont mention anything specific

Any ideas?

Hi While designing sequences on the pallete in the Job Designer - we are constantly receiving the following Windows error message Datastage Designer has encountered a problem and needs to close Error Signature AppName dsdesign.exe AppVer 7.5.1.35 ModName ntdll.dll ModVer 5.1.2600.2180 Offset 0003426...

When DataStage EE finds that a target columns metadata does not match the source's <B>and</b> no explicit conversion has been made but an automatic conversion is possible( like converting from int16 to int32), it does the conversion and warns(informs?) the operator that DataStage had to do an opera...

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 That solution does seem viable - and we were thinkin...

If I am not wrong the DB2 UDB API has the Toggle Switch for
Treat Errors as Non Fatal in the Before/After SQL Tabs which alleviates this problem

Do we have a similar option in The DB2 Enterprise Stage.

thnx

WHY do you want to run a DELETE statement that will never delete any rows?!! The delete statement is part of the rollback back logic - deleting any rows that got committed on a job abort in the previous run The where condition(in delete) holds the timestamp for the last run - deleting any records i...

Hi I am trying to execute a Delete statement in the Open Command section of an DB2 Enterprise Edition stage ex - delete from table where 1=2 My doubt is if the where clause does not return data the delete statement returns an error code like : db2 => DELETE FROM CARD.ADARSHDUMMY WHERE 1=2 SQL0100W N...

Hi As part of our Error Handling logic we need to check >whether a given date valid or not Ex - 2/2/1999 - Valid 2-02-2000 - Valid >whether a given timestamp is valid or not the Date conversion functions in the Parallel Transformer/Modifier need explicit specification of the delimiter and format str...

Dough! Was copying the wrong segment was copying only the section below [EnvVarValues] which is used "If I'm not wrong" to set default values instead of userdef\User Defined\-1\String\\0\Project\userdef\ which actually defines the variable acc to <EnvVarName> <Category> <JobType> <Type> <D...

Hi We are using Environment variables in out project and are testing copying these variable between projects. This is the Sequence of Steps we've been following >Create new Project ABC >Copy DSParams from current prj directory XYZ to ABC >Copy DSParams in ABC to DSParams.keep Check Creation of Proje...

kcbland wrote:Check out the DS BASIC API DSGetJobInfo, if you give it the token DSJ.ME as the job handle and request the job name, your function will know the name of the job running it.

yep - it worked
was getting muddled with parents
thnx