DSXchange

I guess that you would need to land the file coming out of hierarchical stage to pick it up as a full XML file but if you just need the full XML content you always could refer to the XML content by just providing the root "/" in your next transformer for the description of the column, if t...

The main task here will be to generate a constraint to pass the good records. It should be dinamically created to counter in new lookup values. A regular lookup won't work, you will need either count or index function to detect the lookup value existance in the master record. So here is one way that...

It might be that both trusted and client sessions remain in the system forever exceeding the default value(1,000), this will cause a bunch of other issues. The most notorious one is the ASB service going down, if the services and engine tiers are hosted in different servers, and any feature handled ...

We want it fast, codeless?
-Read the data
-Horizontal pivot
-Apply Unique sort
-Vertical pivot
-Concat columns

How about ODBC bridge? I know best practice is to use IMAM as the entry point....but the job needs to be done...how about importing the table definition in DataStage? A shared table definition will be visible in all IIS components... and you will be able to go ahead with your profiling task

Seth. Could be due to different settings and very specific to your environment..Do you see the users in the AD group in WAS or the admin console? Do you see the users in the Engine server? The users in the AD group still needs to be part of the dstage group. If that is the case then remove the AD gr...

Check if the schema used at run time have all fields as ustring, if yes then add an environment variable to the DS project name it "NLS_LANG" and set it to "AMERICAN_AMERICA.WE8MSWIN1252", add it to the DS job

Let us know how it goes

I would check if last time was stopped clean by looking at the logs and searching for any Java process running in the server. If any present that will be the culprit of your issue..

Try calling the store procedure from a regular Oracle connector instead of from the Store Procedure stage, set the environment variable CC_MSG_LEVEL in the DataStage job to fit your desire level of messages...The connector will show the logs Also check if NLS is enabled, watch out for VARCHAR parame...

The DirectoryCommand.sh from the ASBNode directory allow almost all operations that one could execute from the Console. For the special characters just surround the value with quotes DirectoryCommand.sh -rm_grp_roles 'Group DSDev' RoleId Without the RoleId all roles will be removed from the group. T...

Executing from DataStage data rule stage is a viable solution, you have way more control of the process in a DataStage job/sequence than what you have when executing directly from IA....

Still the licenses for DataStage clients are required. Each windows client/desktop required a separate license

All connections to the service-engine from same desktop/computer are cover by one license

For those who needs it, Information Server 11.5 Fix Patch 1 in Fix Central site

Http://www-933.ibm.com/support/fixcentr ... er_linux64

Are the two machines where the projects exist connecting to the same WAS level (Server network Deployment, Liberty) If not that might be the cause...they issue different ssl certicates... And you would need to permanently accept both ...try comparing the objects with the command line counter part ut...

I guess that you also cleaned up the field markers -@FM- values in the user variable activity. Did you?

Convert(@FM,'', commandOutput)