DSXchange

Hello, We need help in deciding the best approach to integrate data cleansing and standardizing tools with DataStage. One of this tools is Code1 from Group1 software which does Address standardization and the other one is DataRigth from FirstLogic for Business name standardization. Our question is i...

Greetings, Has anyone had a problem with the FTP stage working for a DNS name but not for the corresponding IP address? Detail: On NT 4.0 DataStage 5.1, when we FTP using a DNS name, the FTP stage works fine. When we change the DNS name to an IP address it aborts and gives a log entry of: JobName..f...

Hi, Thank you for reply.But using ftp stage I can do transfer of one file.How do I transfer the multiple files from multiple directories Regds Tina On Tue, 29 Jan 2002 Ray Wurlod wrote : > This is exactly what the FTP stage type is used for. > This is a plug-in > stage type: if you dont have it inst...

Hi all, were using a transformation (including 32 jobs) which connects to a MS-Access DB via ODBC on a Network map. So, the transformation start and abort on first job, sometimes before the second job starts. If the MS-Access DB is on a local drive everything is fine. So it seems, there is an connec...

Hi Wong, Ive checked in the log file of the installation made via telnet and there isnt the message about the StartDtscreenQixthat. Here I send you the message write about the service start up in the log file: **************************************************************************** *************...

Thanks, Giovanni. Ill give it a try. But have you received the message that the StartDtscreenQix not found message during installation (as in the installation log),when starting the uv -admin -start and -stop. Thanks alot. Rgds, Wong ----- Original Message ----- From: "Giovanni Boccia" Date: Tuesday...

This is a topic for an orphaned message.

I would not do this in code, because of the difficulty in finding a reliable algorithm for isolating country code. I would do it using a DataStage job with N lookups conditionally executed. Presumably you strip off the leading zeroes but it does not matter if you dont (it affects only the key values...

Hello, I am not an expert in UNIVERSE BASIC but I would like to have a routine which will take a number and produce me with a string. I am just wondering if somebody can help. The situation is: - I have a hash table, called country code with columns country code and country description - I have an i...

Please DO NOT use High Priority on e-mail you post to the list. Monday, January 28, 2002, 11:24:05 PM, DS Wong wrote: > Hi, > Im having problem starting the DS server, when I run the uv -admin - > start it gives a message stating > "/etc/rc2.d/S99ds.uv StartDtscreenQix: not found" > When I try to do...

I need to format text and send it as email letter from DataStage.
Is there any "new line" special character? How to put leading spaces?

Thank you,
Leonid Frumker

Hi Wong, Im testing DS 5.1 installation on my Sun Solaris and I was running in same as your problem. Here as follow I send you my test case: Working directly on Server console WITH root USER, I recive your exacly message using the S99ds.rc (in etc/rc2.d) script or ./uv (in $dshome/bin) script. Worki...

Try using uv -admin -stop as either root or dsadm. On HP11, the startup/shutdown script should be at /sbin/init.d/ds.rc and linked to /sbin/rc2.d/S999ds.rc (for startup) and /sbin/rc1.d/K999ds.rc (for shutdown). At 03:41 AM 1/29/02, you wrote: >Hi there, > >Will be really nice if someone of you, hav...

For solaris, the uv -admin -start should execute /etc/rc2.d/S99ds.rc start. I have tested this on our inhouse Solaris 8 with 5.1 DS and it works fine (both with uv -admin and directly executing the script as root). I am curious if there is some environment variable set that may be causing this probl...

Hi there, Will be really nice if someone of you, have found (and maybe solve) the problem that Im running into. Ive installed DataStage 5.1 on HP-UX 11, and everything seams to be perfect. The only problem is that I cant stop the DataStage service with S999ds.rc. The message that i recive from the s...