DSXchange

More Beers?

No is the answer. Without declaring in the input structure you cannot access them in the code, so if you have different number of value fields; your code won't be able to cater for that. The number of value fields can change so they won't be declared in the input structure. Is it possible to read th...

In your case by default dataset folder is holding the data files and the header (.ds) files are most probably in your project folder somewhere. [Search the RT_xxx folders, if you know the job number which created the datasets search those RT_xxx folders]. From there you will be able to do what you i...

Good news is - Your projects are intact. There are more patches to get from IBM and install for them to get displayed. Contact IBM and report this, we experienced the same during this upgrade.

That's a rare scenario. Should be quite exciting to do this, here are few pointers: >> Export the IADB repository from the source machine and import the IADB repository to the target machine (Should be homogeneous databases). IA repository holds most of the current project related information. >>If ...

Did you re-start after the install? Do a search to find if this file exists Ex:You can find in this folder mentioned: ~IBM\InformationServerXX\Clients\Classic if exists could be a path / dll registration issue. Also check if DS related programs are in the Exception tab of the firewall. Ref. this link

Not really recommended. V8.1 has got new parameters which are not in previous versions. A small example: V8.1 has these 2 very important parameters which are not in 7x RTLogging ORLogging Copying the whole DSParams file from V7x to V8.1 won't be a good idea. Yes, you have to copy... I did not copied...

DSParams file to be copied from 7x to 8.1 ????

sheema wrote: Did you copy the Configuration file and the parameters file too.
How did you do that.

mekrreddy wrote: Datastage Export/Import would take care of parameters defined.

Check out the release notes: New features and changes in Version 8.1 IBM InfoSphere Information Server Notable one: DataStage logging was changed at release 8.1 to log job run detail records into the operational repository, (xmeta) rather than the local project level log files, (RT_LOGxxx) that we u...

I have a blog post on the same - Surrogate Key Generation in DataStage - An elegant way. If you know to use DataStage Job Control Interfaces specified in Advanced developer guide this will be really helpful.

These options also depends on your C++ compiler. Most probably you have it wrong in there.

srinivas.g wrote:Post your Server O/S ?

for Sunsloaris O/S,

APT_COMPILEOPT -dalign -O -PIC -library=iostream -c
APT_COMPILER /opt/SUNWspro/bin/CC
APT_LINKER /opt/SUNWspro/bin/CC
APT_LINKOPT =-G -library=iostream

I have a blog entry DataStage Parallel routines made really easy which you might find useful.

With IBM Information Server (DataStage 8x), Teradata Connecter for Teradata Parallel Transporter (TPT / Teradata PT) joined the TD stages fleet. Two access methods/modes of execution available in this stage: 1) Immediate - For Selector, Inserter... operators. Same as CLI interface/API. (No Load/Unlo...

Table differencing is one way to capture delete delta on a non-audit (without change recording columns) table without Change Data Capture. Maintain a copy of the table (Staging area? Anywhere you can) and use SQL MINUS operator to find the delete delta: SELECT * FROM previous_version MINUS SELECT * ...