DSXchange

Even the backup didnt work. what shall we do now?

someone or some thing has deleted these files.

I am sure no one has deleted the files, as I was the only one using through Designer.

Anything ideas what could be that something, so that we will try to make sure such things don't happen.

I got the error Failed to connect to host: ... (User name and/or password incorrect(80011)) Making use of search, I followed the following steps. a) User Name/password are correct b) unable to login from different client application as well. c) I can ping to the server. d) The port 31538 is not bloc...

I am facing the same problem now, tried everything listed a) User Name/password are correct b) unable to login from different client application as well. c) I can ping to the server. d) The port 31538 is not blocked. e) Unable to login through DataStage Administrator. But one information I have is, ...

Craig I dont know why they are using script

What's your database?

my intention is just to execute a bunch of sql statements.
i dont need to perform anything within the job, other than execution of sql statements.

what is the most optimistic desgin of the job?
i mean which is best to use,(eg:odbc or oci or oracle plugin)

thanks

Ah, ok. You can't do this before sql so put that from your mind. Your two options are before job or before stage and I'd suggest the former. I need to run this PL/SQL after making the connection to database (i.e. opening the session) and before making and any other(select) SQL queries. so would the...

sorry about the ftp..... I was thinking, need to connect to that server and thats all used it... Can you run sqlplus from your datastage server? You should be able to. Run a sqlplus command and excute your query. yes, I am able to connect from datastage server via sqlplus CLI. I wrote a script for i...

You will have to incorporate that pl/sql script into a shell script, kinda like a "here" script. Search the forum or on the net for examples of an "here". See this example where Ray describes a "here" script for ftp. I was trying to ftp ftp ServerName --- of database, ...

You will have to incorporate that pl/sql script into a shell script, kinda like a "here" script. Search the forum or on the net for examples of an "here". See this example where Ray describes a "here" script for ftp. I was trying to ftp ftp ServerName --- of database, ...

I just tried to execute multiple statements in Before button of oracle plugin and it works :D

How can we call the PL/SQL script from Before button of oracle plugin?

Lets say I have a script abc.pl on unix server. How can I run this on the database?

I guess this would be a layman question, but what if I use two statements in Before button of oracle plugin (will it work?) The database is down, so I can't test is as of now. ops$oracle.alter_session_set_guard('ENABLE'); insert into temp_table values (#value1#,#value2#); We don't have priviledge to...

Can we have PL/SQL statements in oracle plugin (in the before button of the plugin)?
I am getting this

You have run out of space on the file system where the hashed file lives. RESIZE makes a copy of the hashed file, so you need another file system that has at least this much space - plus the overhead of the larger (64-bit) internal pointers. RESIZE has a USING option that you can use to specify a f...

Hi, i am trying to convert a Hashfile from 32 to 64 bit. I created a hash file,using Account Name. This hash file contains 60 Million records,with 500 bytes of each record length. While, conversion,it shows an error that there is No space in the device. Resize: Error on hash file not resized mkbdfil...