DSXchange

Hi, I am trying to read data from a ODBC Connector Stage. Job design is simple with ODBC stage as source and sequential file as target. It runs fine for normally but when I turn on 'Enable Partition Reads' feature of ODBC Stage and give the table name & column name it throws following error. The...

Hi, I wish to use a third party ODBC driver with datastage. I installed the driver with unixODBC driver manager. The driver files were loaded to /usr/local/lib. I wish to use this driver with DataStage ODBC stage. I made corresponding entries in .odbc.ini & uvodbc.config, added /usr/local/lib in...

I am not able to connect to my database through ODBC Connector Stage in Parallel jobs. Server Job ODBC Stage is working perfectly fine. After typing in DSN Name, username & password in ODBC_Connector stage it gives: "The connetion failed" error when I test the connection. I am using sa...

Hi, I have to split some colums of input data into multiple rows . I searched for this in this forum but pivot is mentioned in all posts which I suppose do not work for variable number columns without any pre-defined upper limit. In other posts its recommended to write a custom routine for this task...

Hi, I wish to connect to postgres database. I am using standard unixodbc v2.0.0 drivers that ship with RedHat 4 enterprise edition. I am able to connect to the database and can load data from a database table to a sequential file. But 'create table' & 'drop table' functionalities of ODBC stage a...

Well, I am using Windows. Here first environment has to be initialized by "db2cmd" command - which opens up a new command prompt window, where i can type db2 commands. >What is the output of 'ResultText'? When I use DB2Cmd1 = "db2cmd; db2 connect to TEST user Administrator using pwd ;...

I wish to execute some DDL commands - "drop trigger <trigername> " in before job subroutine and "create trigger<trigername>" in afterjob subroutine. As I could not get DB2 stage to execute DDL commands which do not return any result set, I am using DSExecute() in a before job sub...

jhmckeever, thanks for the reply. So, here I will have to create the named pipe before hand or through java application. and will have to share the path/name with DS Job. If I get it right, named pipe will be accessed through sequential file stage like any normal file. Simple Job design(keeping asid...

Do you already got RTI stage installed?? Under the real time tag, I only gave xml stages installed, NO MQSeries stages installed. I have been reading about MQSeries and SOA for a few hours now. I figured out that MQ series would best suit to my needs as suggested by kumar. But for that I need to *B...

Actually, I have a custom java application at a server that streams out some data after every couple of seconds for about 4-5 hours a day. I can configure the port to use for streaming the data out. The data stream is in xml format. Now I want to collect that data stream on some other system (where ...

Hi, I have been given a scenario in which I have to capture data from a live feed(can be in xml format, or csv), apply a couple of transforms and then store data into the database(DB2). I wanted to know if it can be done using any of the DS stages?? I obviously dont want to download the whole feed i...

Job parameter values can not be changed once the job is running.

oh! then there must be someway out, I mean if I have more than one such variables then I can not use DSSetUserStatus.

>Well... you would do that to pass data between jobs. Usually, to pass something between stages, all you need to do is add that new field to the link between the two stages. Why make this more difficult than it needs to be? Actually, I can not use link for passing this max_tid value because I have t...

hi all, What I am trying to do is, just reading a max value from ODBC stage, setting a Job variable to it in one stage and then using that Job Variable in some other stage. I am setting a Job variable in a transformer stage through a simple routine - setID(Arg1) : max_tid = Arg1; Ans = max_tid; max_...

Kumar,
yeah, it appears same in other projects as well


Ray,
Mine is win2000 server machine, and the version of DS is same 7.5.1A. (coundn't read rest of your message as I am not a premium member yet).