DSXchange

Need more info. Can you please copy paste the error message when you try to view data?

Thanks
Jay

this process has been shelved ...

every time u run the job, some 2-3 log tables are created...if there are errors u have to delete them and re-run your job...u can view the log tables when do a refresh in the teradata client....they will be created in the same schema as your other tables... i am forgetting the name of the log tables...

Check if u have given all the connection parameters to the database....user/pwd/remote server (database name)....

Jay

I follow these in a sequence. kill -4 if i/o error kill -15 if application error kill -9 means asking the CPU dont schedule this job anymore Ray D told me about the "graceful kill". i am not having much problems thereafter. 1st i do kill -4, check for ps -ef"|grep <username> The proce...

thanks, Ray...will keep you all posted....

till now the client is working out the exact procedure they are going to follow...

Yes, you are right. Its a PDF file. So i think all i have to do is FTP it to the Print Server. I have its IP Address. It should automatically get placed on the print que. i have to ask the client some more details. How exactly are they doing it currently, outside of DataStage. i'll keep you posted, ...

Hi All,

Has anyone ever sent a file to a Printer ?

Is it possible to do it in DataStage ?

The printer is a remote printer. Checks are supposed to be printed out by the printer.

Thanks in advance
Jay

Thanks, Ray.

We came up with a solution.

I wrote a shell script to delete files. We placed it on the remote server and called it via the scheduler.

Thanks all for your suggestions,
Jay

Hi All, Thanks for the replies...sorry , i was not clear enough... here is my scenario. Datastage runs on Box1, Solaris 5.8 Archiving is to be done on Box2, AIX. There are folders here where we will be keeping our archived files. My requirement is to delete older files depending on the interface. Fo...

Hi Ray, When i embed the find command in the ftp script, it complains Invalid command. FTP cannot recognize "find". #Build and run the delete file script echo =================== echo About to delete files from $tdir echo "open $server user $user $pwd cd $tdir prompt off find . -atime...

Its a PX job. I fixed it. But i am not convinced by the solution . I had to update all the columns instead of the listed 3. So the target had all 17 columns. The job ran fine. But i dont know how this change affected it. I had ran it some time back(1 month) with update to the 3 columns. Thanks Jay

Hi All, I am getting this error while updating a Oracle 8.1 table Terminate.terminate,0: Open failed for update. Update is: UPDATE schemaName.EMPLOYEE SET END_DT = :END_DT, POST_DTS = :POST_DTS WHERE (EMPLOYEE_NBR = :EMPLOYEE_NBR) sqlcode is: -1475 esql complaint: ORA-01475: must reparse cursor to c...

Thanks, Ray.

I googled and found out that i have to use the "find" command where we can specify the number of days.

Thanks
Jay

Hi All, Here is my requirement. I have to delete older files based on timestamp. I have not started developing yet. I need some ideas to achieve this. My idea: list files : ls -ltr get file names : cut -c 55- get last file: tail -1 then give the rm command. The problem is there might be two or more ...