DSXchange

I'm surprised that no-one has recommended Search to you yet

Try - if Trim(NullToEmpty(Out_IRI_UPC.PC_ID))='' then "N/A" else Out_IRI_UPC.PC_ID

Thanks Ray. Our version is 8.0.1. I'll raise a support request with IBM.

Dim table Oracle Enterprise stage | | Reference link Primary link | Source table-------------------------SCD----------------------------------.\NUL Oracle Enterprise stage | Output link Sequential file stage | | Dim changes link | Peek stage As an exercise, I've created a simple job using the SCD s...

If you have the same problem as this viewtopic.php?t=119030&highlight= then it's a bug and a patch is available.

As long as a Sequence Job is involved, then build your date string in a UserVariables Activity. It can then be used downstream in whatever you are using to create or rename your file.

For what it's worth, we are doing something like this without using server jobs. Here's what we do. Create a Sequence Job called (for example) Sleep_Seq. Check Allow Multiple Instance. Have an Integer parameter called SleepSeconds. Add a Routine Activity: Routine name = ExecTCL; Arguments - InputArg...

Google_WST,0: Error: TJClient::initialize: unable to create Java Virtual Machine; classpath = java/lib/wsclient.jar java/lib/axis.jar java/lib/commons-discovery.jar java/lib/commons-logging.jar java/lib/jaxrpc.jar java/lib/saaj.jar java/lib/wsdl4j.jar I had this problem recently and was able to res...

A patch is available to fix this. PATCH REPORT FOR ECASE: 130688 PRODUCT: Information Server VERSION: 8.0.1.1 (FixPack1) PATCH NAME: patch_e130688 COMPONENT: PXEngine PROBLEM REPORTED/Implementation Details: PX job run with Oracle EE stage throws error. CAUSE OF PROBLEM: FIX SUMMARY: The fix introdu...

Did you do a full uninstall? That means cleaning up the registry and install disk to remove *any* traces of the old client before installing again. That and rebooting. thanks for the response No just did usual client install & Uninstallation,How can we do cleaning up the registry and install di...

even uninstalling & re- installing the client has not fixed this problem...however from another pc, I can work normally after logging into datastage....
Also uninstalled the latest version of IE 8,just to make sure no sort of pop blocker is there.

any thought?

Hi, After rebooting my system, I am able to log in datastage & open the job but not able to open the stages like Oracle EE & copy stages etc in the job and subsequently client is hanging. But when logged on with same user id in another PC,I am able to do all the operation normally. Prior to ...

Hi All, Incase of low number of records, Jobs are aborting while writing zero records thro' one of the node. Present job is writing 21 records for 2 nodes, its working fine if rows are divided as 10 or 11 between the nodes. But its aborting quite often in case rows are divided as 21 and 0 between th...

Running the jobs with Disable Constraint False as workaround

lstsaur wrote: Restart the production server? Are you working in 1 employee only company? BillB, You need to go your ../DataStage/PXEngine.751/java directory to re-start the jobmoninit by issuing the follwong command: sh jobmoninit start $APT_ORCHHOME Istsaur, Its windows OS not Unix.....What is eq...

As a workaround, trimming the column thro' close command....

many thanks