DSXchange

Perhaps you could post the SQL you are trying to emulate?

Note that ...
... is the same as

arasan, If I'm following your post correctly you're trying to emulate a SQL 'NOT IN' clause using a succession of OR'd clauses. To get the logical equivalent of a NOT IN using this method you must AND your clauses together. If ( SRVC_TPY_CD_ID<>'N' AND SRVC_TPY_CD_ID<>'A' AND SRVC_TPY_CD_ID<>'Z' AND...

For older versions of DS (where this functionality wasn't available) I use the following script. It takes a file pattern and echos all lines from all matching files with each line prefixed with the name of the source file: #! /usr/bin/ksh #------------------------------------------------ # Usage: ge...

The line that catches my attention is: The number of reject datasets "0"is less than the number of input datasets "1". Does your transformer is feed a stage that could experience a write failure for some reason? In that case, the transformer will require reject link. Also, check ...

As you'll frequently read here, the DataStage repository is not UniVerse (the code branched some time back, I believe), however I still find the UniVerse documents good for background reading ... http://www-306.ibm.com/software/data/u2/pubs/library/96univ/ This advice somes with "No Warranty, I...

RAI, Check your client installation directory. E.g. C:\Program Files\Ascential\DataStage\Docs\XMLPACK_20_Designer.pdf Note that you don't read/write XML file specifically, you just read/write sequential files, which may or may not contain XML data. The XML stages operate on input and output streams ...

You need to make sure your $APT_ORCHHOME/lib directory is in your library search path. This path is defined by the environment variable SHLIB_PATH, LIBPATH, or LD_LIBRARY_PATH, depending upon your system.

E.g. HTH,
J.

Hi Satish, Gosh - That's a rather broad post if ever I saw one! If you want to understand more about MQSeries I suggest you take a look at the <a href="http://www-306.ibm.com/software/integration/wmq/library/index.html">manuals</a> or one of the user sites like <a href="http://www.mqs...

You probably could do with reading <a href="viewtopic.php?t=104554">this</a> excellent post by Ray.

J.

Do a quick <a href="search.php">search</a>. Maybe <a href="viewtopic.php?t=100924">this</a> helps you get started with the problem?

J.

Raftsman,

1. Go to 'Columns' tab of you file stage
2. Click 'Load'
3. Click 'Import' -> 'Sequential File Definitions'
4. Specify your file then hit 'Import'

The resulting dialog will walk you through the process. maybe you'll spot something amiss there?

HTH,
J.

pradkumar, As chulett said, your Oracle function needs to execute in a query (say against dual) like so ... SELECT Function_name( "Arg1", "Arg2") FROM dual If you insist on using your function and want to call it from a STP stage you could create a new "wrapped" stored ...

Raftsman, I assume that you actually want help with your PX sequential file stage (or are you really aiming to start a discussion on "why something so easy in the Server DS world is so complicated in the Parallel world."? :-) That's a big topic! But if you want some help with your sequenti...

Jothy, Parallel jobs do show performance statistics in the same manner as Server jobs. Have you set performance statistics visible in Designer? (Right click canvas, "Show Performance Statistics") If you're using v7.5 then check out section 6-18 (Job Monitoring) of the Parallel Job Advanced...

You could use a Field lookup technique as detailed by Ray in this post:

viewtopic.php?t=102543

Ray's technique looks up Month names, but you could just as easily look up month end-dates.

J.