DSXchange

A couple of reasons jobs get "abnormal terminations" on transformer stages: 1. A function is called where the arguments passed are manipulated inside the function. This means using function in a constraint, derivation, or contraint and inside the function the logic changes the value of Arg1, somethi...

Doris, Did you resolve the problem mentioned below? The reason I ask is that we have been having these intermittently for a while and have just resolved them. If it has not been resolved and you still have the logs, let me know and Ill see if our situation applies to you. You dont mention your DataS...

Hi, We are using Datastage to export from R/3, using ABAP process. We have same problems, when we try to do the FTP from SAP, to our destination file. In ABAP plug-in, we fill the option to do the FTP of the information, from SAP Server, when we try to execute the Datastage job, in Director, it retu...

Jason, weve had significant problems attempting to workout exactly how the XML stage parses repeating elements and weve discovered a couple of things that work for us. These comments relate to DS v4.1. Firstly, the order of elements must match the order in the DTD. Where you have a repeating element...

Hello All

Anyone looking for a datastage contract in west London
please contact me ASAP.

Regards
Martin Battaliou

This is a topic for an orphaned message.

Hi, you can backup a project on server side by using uvbackup. Example for Unix: #!/usr/bin/sh DS_HOME=`cat /.dshome`; export DS_HOME BACKUP_PATH=/emc440/backup PATH=$DS_HOME/bin:$PATH BACKUP_FILE=$BACKUP_PATH/full`date +%Y%m%d`.uvb LOG_FILE=$BACKUP_PATH/full.log PROJECTPATH=/disk05/Projects TAPEBAC...

Hi Denzil, Export is normaly something you do on a Client machine. On the DataStage-CD you find a commandline export and import-tool. Then you only have to have a Windows PC (95,98,XE,NT,2000,XP home,XP pro) with DataStage ClientSoftware and a scheduling tool and you can schedule export on a regular...

Hi all

Is there a way you can schedule the exporting of a whole project?

We are on datastage 5.2r1, Solaris 8

Denzil

All, I have just been tasked with a datastage project to read XML data. I am new to XML but have come to understand it well enough. The problem that I have is that in my XML file and corresponding DTD I have a number of repeating elements but I dont seem to be getting the right number of rows being ...

Curious if anyone can help me. I have a job that, via a single pair of Sequential and FTP stages, send three files from my Unix server to a Mainframe. My problem is the fact that, in this configuration, all three files transfer at the same time. What Id really like is for the files to transfer, one ...

There is a family of statements in BASIC (note: statements, not functions) that are used to search dynamic arrays. LOCATE searches for a completely-matched element, at only one level of delimiter. FIND searches for a completely-matched element, at three levels of delimiter (field, value or subvalue)...

When you change a transform, you need to recompile all the jobs that use that transform since the code of the transform is included in the code of the job. When you change a routine, you do not need to recompile the jobs that use the routine since the code is external to the job. HTH, Alan Williams

Hi Rui, Ive done it the way you do, but I wrote only one row into the Hashfile. It works, dont make date a key in your hashfile. Wolfgang > -----Original Message----- > From: Rui Soares [mailto:rui.soares@novabase.pt] > Sent: Wednesday, September 11, 2002 12:16 PM > To: Datastage-Users (E-mail) > Su...

Hi all, This very little matter amazed me yesterday : i just wasnt able to use the FIND function into a transform : FIND %pattern% IN %string% SETTING fieldNumber THEN fieldNumber Although the syntax seemed to be right (no matter within a routine), a "general syntax error" occurred. Since a transfor...