DSXchange

From UNIX? You'll need to get your hands on ODBC drivers for Access, but at least SQL Server wire drivers ship with the product.

singhald wrote:what is that RMM stage ?

An old joke - the Read My Mind stage.

Is this your first attempt at Oracle via DataStage? Have you configured DataStage for Oracle yet? If those answers are "No" and "Yes" then suggest you do not have a legitimate tnsnames.ora entry specified in the stage. Verify which stage you are using as well, OCI or ODBC? Unless you are using a thi...

Well, you're close. You are selecting five columns so that matches what is in the stage. Your problem looks to be the fact that you are using a bind variable for column one when in fact you need a bind variable for each key column and you said the key column was the fifth column. Change :1 to :5 and...

suresh.narasimha wrote:My administrator says he had set up sftp connections and opened firewalls.

sftp != ftp

Unless this was removed from the 8.x release, the way to install plug-ins outside of server install/update is the command line 'package installer' or dspackinst. You might check and see if that's still out there under $DSHOME/bin or elsewhere. Can you expand on what exactly this means? "The plugins ...

Double-check what you think you are sending as the Pathname.

OK, not sure why I missed them. Found the last access and modification date and time fields, 13 thru 16. There's also field 17 for 'Time and date of last status change' that states it is the creation date on Windows NT, out of curiousity where is the UNIX creation date retrieved?

Hmmm... I went through the BASIC manual before I replied for both FILEINFO and STATUS but didn't see that. Guess I need to look again.

Search.

Yeah!

Right. Got that the first time. Understand that when the table is empty there is no data to view. So what you are seeing if probably just an artifact of the viewer and nothing to worry about. How does it look when there *is* data?

Neither can I. Exec_CMI_Business_Unit_Procedure..ODBC_91: DSD.BCIConnect call to SQLConnect returned informational message. Seems that you may need to find out what the 'informational message' was. It may very well be the "String or binary data would be truncated" message noted in your post. Not qui...

No need for stage variables. Search the PX forum for MMDDYYYY and you'll find several discussions on how to get that output format.

If the table is empty, there's no data to view.