DSXchange

Another solution to try would be to use the TEXT file ODBC driver and the ODBC stage. As long as you have column headers that are always the same, even if the columns aren't in the same order it should work just by doing "select a,b,c,d,e,f,g,h from text file name". I'm not sure of the exa...

Eric, Thanks for your response. I'm not sure how I'd get support to get the right guy on a web session. Support says they checked their problem system and said no one else has had this problem. I relayed my observations about the values in the database and complained that no one was working with me ...

When I open Operations Console the CPU Usage chart (lower left corner) always shows 100%... If I run topas it shows a very minimal usage, 1-35%... but not 100%. I have installed a patch to allow me to change the Work Load Manager (WLM) parameters (I couldn't change anything before)... I did not try ...

Thanks!

You may also need to make sure that the HANA libraries directory(ies) are in your libpath environment variable (or SHLIB_PATH?... depends on your OS)

Hi Folks, I have a two tier DataStage install. DataStage Engine on one tier and WAS and DB2 (Metadata Repository) on the other tier. The isadm user exists on the WAS/DB2 tier, but not on the DataStage Engine tier. Most everything seems to be working, but I noticed that when I ran ISALite "Gener...

Hi Craig, The project has been recovered. I contacted IBM Advanced Level support. At their request, I sent them the DS_JOBS and DS_JOBOBJECTS directories. They said something about DataStage version 7... And sent me a DSX back of all the jobs in the project. I didn't get any more details than that. ...

Thanks, qt_ky. I thought of that... and did just what you suggested. Same error. New information: I tried to export the project with the dscmdexport command. It found DataStage executable jobs, but did not export the Source Jobs. Since all we used to have was this set of UNIVERSE files my gut is tel...

Folks, It's been a long time since I posted. Sorry for the absence. I am in the process of moving to a new v11.3 DataStage server. My SysAdmin loaded the Parallel engine on this server by mistake. I don't have a license for the Parallel engine on this server, so I asked him to uninstall it. He re-ra...

Hi all, I'm just posting this in the event that someone else encounters this problem, maybe this will save someone some sweat. My users starting having problems logging in. I noticed that I was getting password expired errors in the SystemOut.log. I shutdown WAS and tried to restart it. It wouldn't ...

Hi Brian,

You might try clicking on Advanced Find in your Repository view (normally on the left side at the top). Put in the name of JOB-B and search. If it's in the project, DataStage Designer should find it.

Good luck.

Are you saying that even though it's there, it's not using that shell? Or that you cannot change the line in the file? Or something else?

Will you be using Oracle Exadata as a data source/target or as the xmeta repository?

You can set the shell that will execute the script by putting a line at the top of the script.
#!/bin/sh
Or
#!/bin/ksh

We're converting to DataStage v8.7 and I've run into a question. If we're supposed to convert everything to connectors, how do I code the "multi row result set" functionality? This choice isn't available in the Transformer when using the ODBC connector like it is when using the ODBC stage....