DSXchange

Sunshine,

I think that if you have a "controlpanel/Administrative tools/Telnet Server Administrator" visible then you installed the Windows TELNET server; which is why your DataStage telnet service isn't functioning.

Please try to stop and start the services using the DataStage applet in the control panel itself. This applet is called Ascential or DataStage (I can't remember) and has the Ascential logo; this application will start and stop all the services together and in the correct order.

Meena,

you are welcome - but if the post helped you find your solution, please post what you did here so that this thread might help others when they do a "search". Thanks!

You can download IBM NotesSql here

The only way to connect to a Lotus Notes database is via the ODBC connectors in DataStage. There are several third party tools that expose (portions of) the Lotus system to ODBC, but I think that IBM's NotesSQL comes with the product and you can use that.

You can use the user return variable, this method has been discussed a number of times, I just found this thread on the subject

Sunshine, what OS are you running on your PC? Do you have any other packages installed which might conflict with DataStage Telnet's port - such as a third-party TELNET server (not a client, that is not an issue)? If your PC is at the low end of the performance scale then you might also have had a ti...

No, don't change the existing instance; there is no reason to do so, the /.dshome will continue to point to this instance. The 2nd and further instances are those that have a different path. Just make sure that $DSHOME is set to the appropriate path for your session's requested instance.

Each instance will have it's own path to the home directory; the /.dshome entry will only be valid for one of your instances, the other one(s) need to be attached to directly. Similarly you will have to append a port number when connecting to a second instance from any one of the 4 client programs, ...

Hello Meena, the error message is telling you that the physical file layot of the sequential file does not match the column metadata that you have it. It noticed the error in the column called UNIQUE_NAME and is warning you that there is still data in the file record even though, according to your m...

No, I will not explain the function you pasted. At least not in the way you asked. It has a SPACE() function, a TRIM() function, and LEN() function and an EREPLACE() function and a string concatenation function. All five of these functions are simple and well-documented. If you wanted to understand ...

Arasan,

you have a variable called @INROWNUM in the transform stage. You can use that in constraints to branch to a different output file depending on the value of @INROWNUM.

This will take you less than 5 minutes to code if you already have your source, one transform and target defined.

Ravij, The EREPLACE function will replace all occurrences of the string; so in your case if you do use EREPLACE you will turn "0000200" into "2". In a DataStage transformation all columns are referred to in derivations in the form {LinkName}.{ColumnName}; since I don't know what your exact names are...

ravij,

appending zeroes will change the value of the number. If you wish to format a number with leading zeroes then you should use an explicit FMT command such as FMT(In.ColumnName,'6"0"R') which will make the value "0123" into "000123"