DSXchange

Dhina,

the current release is 7.5.1x. Don't you think that the manufacturer's webiste is a better source for current release information than the user forums? I suggest looking at the vendor's Product Availability Matrix to get the actual version information.

Kalyan, login as one of these users and cd to the DataStage engine directory (cd `cat /.dshome`), then issue ". ./dsenv" to set the environment and issue the command "bin/dssh" to enter the TCL environment. If all goes well, you will get a ">" prompt and can exit back to UNIX via the command "QUIT"....

I didn't realize we were talking PX and not Server, but the precept remains the same. In your case it would most likely be more efficient to use the CFF stage - but since the target is a sequential file the execution will always be serial and not parallel.

You can install as many different instances as you want and if they are at the same version you don't need to use the multi client manager. But each instance needs to have it's own port number to use for the client to connect to.

I think that many of us would like to help you, but

I am getting error at the transformer it self

doesn't help at all - what kind of a error message are you getting and exactly is your problem?

Convert from/to ASCII/EBCDIC is one thing that the CFF stage does and that the normal sequential stage doesn't handle. If you have just a few columns and performance is not of paramount importance, you can convert on a column-by-column basis and also convert non DISPLAY type COBOL fields using the S...

Put simply, if you have data with 2 columns, a CHAR(10) and a INTEGER(5) and you write it to a text file called "seq.txt" and also to a CFF stage file called "cff.txt" you can do a UNIX diff on them and they will be identical (you need to set up the separators, terminators and other things to be the...

There is no such thing as a CFF file. The "Complex Flat File" stage is used in DataStage to read a sequential file which may contain complex COBOL structures that a normal sequential file stage couldn't interpret correctly (something with OCCURS DEPENDING ON, for example).

Madhavi, the most frustrating thing is hearing "it's not working" without getting a description of what isn't working; that doesn't help solve a problem. You have now confirmed that the hashed file contains the column in string form in the format of "YYYY-MM-DD HH24:NN:SS". Now you need to find out ...

Naveen, I think that might be too Draconian and bothersome for many posters. The negative feedback that posters (like myself) sometimes leave for glaringly obvious transgressions seem to work well enough - at least for the time being. Perhaps the search button / feature could somehow be graphically ...

Could it be that you missed the space character before the 00:00:00?

Yes it is possible. The question has been asked and answered already in several threads. Look in your client's DOCS directory for the pdf file entitled multiserv.pdf for instructions on how to do this.

There are no conversions performed when you write to a hashed file. If the datatype is timestamp(19) it most likely is already in string display format and is stored that way. The easiest thing for you to do is to go into the shared container and do a "view data" on the hashed file contents. What is...

Whole company departments do nothing but integration testing and there are books written on the subject as well as over 50 million google pages that match "integration testing". So the answers you are going to get here are only going to scratch the surface of what you will need to know. So all your ...

There is no workaround, but you do have the Ascential-supplied tool "Multi-client Manager" to let you connect with different clients to the appropriate servers.