DSXchange

ds_ram wrote:Hi,
I am able to ping using telnet.

I've never heard of software that can do that, ds_ram. Both "ping" and "telnet" are separate utilities and your system might be blocking telnet and DS ports while allowing the TCP/IP level "ping" go through.

Check your "ora.5451.353168.1.log" log file to see the detailed error message.

What sort of security software do you have installed on either the PC, network or UNIX host that might block off traffic? That would be my first thought. You can enter a DOS command "telnet <unixhost>" on the PC to see if telnet works to your DataStage server.

dsonly - welcome to DSXChange. In order to help answer your question you should add a bit more information to your post. Even though some can be read from the error message, you should tell us what stage you are using and what you are doing in it. Does the error happen on view data or when running? ...

try doing a dos telnet to the server using that userid and password ? Since you can connect it would seem the RPC daemon is working, so the cause must lie elsewhere.

You cannot convert the binary to an integer value in the FTP stage. You can use the SDK routine DataTypePicComp3 in a tranform stage or use an intermediate sequential file and read using the CFF stage.

Can you manually type in your query at the TCL command line level and see if you get the same error message, please.

oops, I didn't realize that!

I prefer "Beam me up Scotty, there's no intelligent life down here"

There is no need to do much if your original project was not broken. In your new server just add the project name and the existing path and DataStage will detect the existing project and keep the contents.

What does the file look like when you view the contents from UNIX?

You can read from the mainframe using the FTP stage and then write the data to a sequential file that is declared as a named pipe. This pipe is then read via CFF in the same job and interpreted as per the copybook definitions. Using this method you will process the data row-by-row and not have to wr...

Welcome to DSXchange, Senthil.

It is recommended to use the search button on the top of the forum screen to see if a certain error has been encountered before. In this case, I used a search for the error message and got quite a few threads, the first of which you can find by clicking here

Ravi, the question about Orchestrate architecture is far too broad to answer; you will need to do some preliminary reading, perhaps the first few chapters in the Parallel Job Developer's Guide to start with. You question is like asking "Please explain Operating Systems" - many probably could, but wh...

I think you have extra double quotes around the table name.