DSXchange

FUNCTION AddMonths(SourceDate,SourceFormat,DeltaMonths,TargetFormat) Equate RoutineName To "AddMonths" Ans = @NULL If IsNull(SourceDate) Or IsNull(SourceFormat) Or IsNull(DeltaMonths) Or IsNull(TargetFormat) Then GoTo MainExit If Not(DeltaMonths Matches "1N0N" : @VM : "-1N0N") Then Message = "Number...

Rui, Have you tried restarting the process MetaBroker after making the changes? Any changes to the .config file requires restart of the services. Pavan -----Original Message----- From: Rui Soares [mailto:rui.soares@novabase.pt] Sent: Monday, February 25, 2002 1:44 PM To: Datastage-Users (E-mail) Sub...

Excellent! Thanks for the clarification, Rick. My colleague and I have been compiling our "niceta haves" for Version Control after seeing that empty forum for enhancements over on the "Tools4" website. Well keep an eye out for the upcoming posts and will definately add our two cents in. Thanks again...

The utility can be downloaded from www.tools4datastage.com under the downloads page. I did not load the Installshield for this download it really is not needed there is 1 DLL file that needs to be registered and then the EXE file can be run. Instructions are included in the readme.txt file. At DataS...

Just wanted everyone to be aware of an issue we just discovered with Version Control. This only applies if you are currently using VC under version 4.x of DataStage and then upgrade to 5.1a, so if this isnt you theres not much need to read on. This will also not be an issue if you *start* using VC u...

Alexandre, you have to introduce a load ID for your job runs in your tables. In case of a abort you then can backout previous loads. You should also not delete/update records pysically but "mark" them as deleted/updated. In case you physically delete/update, log the recods temoprary to be able to re...

Hi We are try to install the metastage, but we have some problems. we update the config file in listeneri, and the config file of process metabroker, to : Path=/usr/local/metastage/processmb Port=4379 ListenerServer=172.26.115.48 ListenerPort=2379 CheckTime(mins)=10 MaxActivityDuration(hrs)=24 Log=f...

Brad, Give serious consideration to upgrading right on up to 5.1a instead of 4.2.x, unless youve already ruled that out for some reason. Changes to the underlying engine structure were done to increase performance, and the addition of the Axcel Pack lets you run multiple instances of the same job si...

We are currently running an old release of DataStage (3.1.1r3, feel free to groan and roll your eyes) and will be migrating to 4.2. Our current NT server is running NT 4.0 SP 4, has 1700+Mb memory, a 4-pack Pentium II 200mhz processor, and a 17GB hard drive. Heres the situation. We are testing the n...

If anybody follows weird issues like this one, the resolution was very simple, if completely unexplainable... To recap the whole bizzare story, taken from an email to Ascential Support: On the afternoon of February 15th I upgraded our production environment to DataStage 5.1a and 2.3 of the FTP Plugi...

This utility has been posted to the download section of Tools4datastage.com. Be sure to read the readme txt file as there is one dll that needs to be registered before running the exe file. Warning to this is that if any of your DS design components you have used .'s in the name that any other compo...

To keep the last day of a month cause the date its not valid. And its a easy way to keep it with this month (February). Ben Regu.Saliah@astra zeneca.com To: datastage-users@oliver.com cc: (bcc: Benoit Murray/MTL/DMR/CA) 25-02-2002 09:48 Subject: RE: Help with adding months Please respond to datastag...

My guess is that there was a problem opening, or getting a row from, the sequential file - perhaps it was being written to by another process. One way to be more certain of the diagnosis would be to look at the Transformer stage program RT_BP827/JOB.748385750.DT.1245652560.V0S13.IDENT1 and ascertain...

Hi, Could anyone help me?. We are just trying to insert records from sequential file to DB2 table. Nothing special we do in this job. Job failed with the warning message and the same job was run few times without any problem and after abortion of this job we just compiled and reran the same job and ...

You can use the parameter name directly or load it into a variable from the DSGetParamInfo function. Then you must build the SQL statement. I presume you are executing the SQL statement using BCI functions. TableName = DSGetParamInfo(DSJ.ME, "TableName", DSJ.PARAMVALUE) SQLStatement = "SELECT column...