DSXchange

Hi Since you are using plug-ins to import your metadata, I suppose you are not using any ODBC stages in your job. You need not configure .odbc.ini or uvodbc.config. But be very sure you update the parameters ORACLE_HOME ORAHOME LD_LIBRARY_PATH / LIBPATH ORACLE_HOME ORACLE_SID ORASID Which flavour of...

Hi I have designed a sequence with a server job and a routine. The routine gets me the link counts from the server job using DSGetLinkInfo(). When I manually run the server job and then the routine, the latter runs fine and reports the counts correctly. But when I run them through the sequence, the ...

Hi Ernie, Thanks for your response.. But I had two questions 1. How should I create/import metadata into the shared table definitions and use the same for my jobs in the source/target db2 stages. 2. In case I export these whole set of jobs to another environment what steps do we need to follow in or...

Hi I have a set of Datastage jobs with me. Some of them access a DB2 database through ODBC stage and others through DB2 enterprise stage. But I have observed that the design time metadata for the tables is only stored for tables accessed through ODBC stage and not for access through DB2 Enterprise s...

Hi.. Just a hit and trial... Please push all the CLOB fields at the end of the column definitions and try.....

Hi Can I create new columns in the output of a Modifier stage with hard coded values? I want to avoid using transformers. I also need to do some NullHandling along with the above mentioned requirement, which I know can be done with Modifiers. Also is there any way to incorporate if.. else logic in t...

If you use "Truncate table and then insert rows" internally you will have delete not truncate.

Have you checked whether you or your group is assigned a developer role or an operator role in this project in the new environment?

Please try once with truncate table and insert rows. Actually this does not truncate your table, rather deletes it. So please give a try. Not sure though. Please keep array size as it is, ie 50.

Let us say you need some customized looping logic to be implemented with each of the incoming records (other than sort or aggregate) for which I think you do not have any dedicated DS stages.

Hi I am having Information Server installed on AIX. Initially when the installation was done the hostname command showed the fully qualified domain name for the server and hence the datastage credential is also created against this FQDN. But perhaps later the settings were changed at server level an...

Simply use DSExecute function inside your routine and invoke the PERL script as you invoke normal UNIX scripts. You can search for the syntax and usage over the internet.

Join itself does a sorting of the incoming data in both the links. Using so many lookups in cascade may also degrade performance even if the volume of data in reference dataset is low. So I feel best thing is to break up the job into two with 5-6 lookups in each and use datasets as intermediate stor...

Check the target database stage. Go to Input -> Options. Check in the create table action -> You should have Do not create target table.

Talk to your unix administrator and ask him to include you user id in the same group as used for datastage users.
Telnet to the unix box.
cd /opt/IBM/InformationServer/Server/
ls -ld Datasets
Check the group for this folder, and check you own group.
That is your main issue.