DSXchange

This is a typical DataStage task and often done. You can use the same stage canvas object for the insert and the delete by having two links into it, or you can use two separate stages. The logic of which row gets sent down which link is done with constraints in a transform stage. What logic have you...

I missed that, sorry. You will need to specify absolute pathnames for all objects, since the cwd from inside datastage is that of the project unless you explicitly change it in the command. I would look in your project directory on DOS and I'm certain you'll find the uncompressed objects.

...As far as I know Trim function works for Varchar data type. You cannot use Trim for fields which are of Char data type... You can use the TRIM() function on CHAR, but since the resultant output if of fixed length it will automatically pad the output according to string rules. You can use it to r...

If I recall my WinZip correctly, you cannot use the normal executable from the command line but need to download the command-line version of the code (available on their website); I've used that from DOS before with no problems but can't recall what the executable is called, but I don't think that i...

... However they cannot be run on windows... That is not fully correct. Some versions of EE on Windows will not allow the parallel jobs to be executed, while others do. PX will use the c++ compiler to create binary and object code; such code becomes machine specific and will not execute on other pl...

Ram, the file is imported and created with the default permissions of the user who does the importing. If this is insufficient for others to work with then the user's profile needs to be changed to allow group access. If the permissions for executing the job for the user who imported the job are not...

Nothing here on DSXchange is urgent. If you need something urgently you will have to pay for it. Everyone here is a volunteer and many feel affronted when asked to do things "urgently" or when "this is important"... In your case, since you need the result in a sequence the best approach is to shell ...

Is your hashed file over 2Gb, this would explain your problem.

The message handlers are stored in the project's DSParams text file and are not part of the normal export. You can copy the relevant lines from this file manually if you have several handlers.

Put a call to DSLogInfo('Before Mail Call','') right before your sendmail call to see if it is entering (and perhaps hanging) in that code.

In this case I would keep the kernel parameters the same. If you find that after a period of measurement that your system is not being fully utilized you can think about which kernel parameters (if any) might be changed to make DS work more efficiently in the new hardware environment. But I would no...

The easiest way to get this value is to shell out to UNIX and do a "wc -l {filename}". You cannot successfully issue a call to DSGetLinkInfo() for information about your current run while still running your job, the exception would be to do this in the after job subroutine. You can also use the valu...

psv,

if you installed according to the minimum kernel settings specified in the DataStage upgrade and installation guide on page 41 then what exactly is your question? I would not necessarily go about making any additional changes to these unless you have issues.

StageVar "AntLoc" set to "INDEX(In.Column,'nta',1)"
StageVar "NewString" set to "IF AntLoc=0 THEN In.Column ELSE In.Column[1,AntLoc-1]:'xyz':In.Column[AntLoc+2,9999]"

this will replace the first instance of "ant" with "xyz" in the string in a PX job.

By using DSGetStageInfo() and DSGetLinkInfo() calls and a bit of programming logic you can get the link "direction" information. As Kim stated it is not straightforward but the information is there using the API calls.