DSXchange

Try this :
Type in Delimiter String = '"|"' (single quote double quote pipe double quote single quote)
Qute= None

Is this just an NLS problem?

The file doesn't get FTPed. If you view the data in UNIX (after getting it manually), the characters are displayed fine in Vi editor but Datastage reads it as a ? that is, Datastage does let you "view" data but with a "?" for the unreadable character.

I tried both with and without unicode in Extended property for varchar.

Neither worked.

I am assuming you mean its "-99". Officially its a general server error. It could be that its not getting enough resources that's why it runs fine most other times. Do you have too many jobs/instances running at the same time?

Please correct me if I'm wrong..

Thanks all for your inputs. I had never done that before and hence wished to know the implications.

Hi,

I would like to know is it wise to have a set of parallel jobs being run by a server batch control job.

Your views will be much appreciated.

Resolved it. Something with the Restartable option. I added it and ran it.

This is what I observed : Job id for FTP needs to be changed every time the ftp fails else it will abort. No need to clear existing file.

Guess its time I need to read up about FTP!

Thanks!

Hi, I am trying to FTP in a file from a Windows server using FTP Enterprise stage. I am able to do the ftp from the Datastage server and funny thing is, my job did actually run successfully once :? But after that it has just been aborting! I tried searching on Linux and this forum as well, but I am ...

I will need to get the incoming account data into a load/replace table (getting a table created is very difficult in this establisment! :cry: ) to be able to do the selfjoin+incoming account data join. Anyways, this was a migration project... Will probably go with the sparse lookup or SQL join now :...

Its an account profile weekly history. The incoming count is barely 6000 and the weekly history has got 750 million records falling in that window (thats assuming i am hardcoding the dates). I think a sparse lookup for every account will be better or an in-sql join having the accounts in a temp tabl...

I have the required SELECT privilege. I can execute same query using API stage but I need to do a sparse lookup. DB2 Enterprise stage has not been in use in this installation as they have been using server edition and have recently migrated to 8.1 parallel edition, where again they were using API st...

Actually I'm getting this error on doing a select. Not trying to create a schema. Perhaps there is some privilege issues for the id on the instance/server parameters ie db2 instance (server) and client instance. :?

Did anyone find a solution to this problem? :(

I have an implementation/optimization problem. a. There is a set of weekending dates which comes in a file. b. There is a set of account ids which comes from a second stream (driver) c. There is a history table which I have to query :(over 650million records) 1. To get a subset of account ids from t...