Search found 14 matches

by deepbanerji
Fri Oct 08, 2010 9:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sending files to MQ
Replies: 6
Views: 3626

Download and have the base64 utility in our box/folder. use the command base64 -e filename.zip filename
by deepbanerji
Thu Sep 16, 2010 2:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sending files to MQ
Replies: 6
Views: 3626

SBSA_DW2 wrote:Thanks for that advice. I tried the Folder stage and unfortunately it did not work sending the zipped file.
I am actually encrypting the zip file with base64 and writing to MQ.

Folder stage - Transformer - MQ
(XML - zip - base64)
by deepbanerji
Tue Jun 13, 2006 2:34 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: HASH FILE ABORT
Replies: 19
Views: 5969

Reset the aborted job and get detailed error message
by deepbanerji
Thu Dec 01, 2005 11:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Job Log
Replies: 3
Views: 1711

Job Log

Hi,
I have around 10 server jobs sequenced in a sequencer. The main sequencer job will run through autosys daily. I need all the Aborted Jobs Log and all the warning to be emailed to the Production supervisor. Could anybody please advise me on this.

Thanks,
Deep
by deepbanerji
Tue Nov 22, 2005 4:08 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to handle different DB schemas for Dev, Test and Prod
Replies: 6
Views: 2277

How to handle different DB schemas for Dev, Test and Prod

I have different database schemas for Dev, Test and Prod. When I export my Jobs to Test, Do I need to import new table definitions from the Test Schema and update my Queries in all the jobs or is there any other way to handle this situation.

Thanks,
Deep.
by deepbanerji
Fri Jun 17, 2005 11:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Reading Msg
Replies: 1
Views: 1032

Reading Msg

When I try to read a message from the Queue usign MQ plug In
I am getting following error.

The WebSphere MQ plug-in is unable to process non-string formatted messages.


what could be the reason. I have successfully written the message. But while reading getting this error.

TIN
by deepbanerji
Thu May 26, 2005 1:55 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Joining SeqFile and oracle Table
Replies: 3
Views: 1655

Joining SeqFile and oracle Table

Hi,
I have to Join a SeqFile and Oracle table without using HashFiles. Is there any way to do this.

Thanks,
Deep
by deepbanerji
Tue Apr 19, 2005 2:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Accessing DB2 database
Replies: 1
Views: 1328

i got the solution. i didnt include table qualifier before table name.
by deepbanerji
Mon Apr 18, 2005 11:24 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error Accessing DB2 database
Replies: 1
Views: 1328

Error Accessing DB2 database

Hi, I am trying to access DB2 table. I could import metadata for the table(using table definitions-- import -- plugIn Metadata -- DSDB2), but when i try to run the job using same server name and userid, pw i am getting following error. "Viewdata" option is also giving the same error. Mainf...
by deepbanerji
Wed Apr 06, 2005 12:06 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xml
Replies: 2
Views: 1511

If you are using version 7x try using XML output stage, transformer and Oracle. Import Metadata using XML import table definitions.
by deepbanerji
Tue Apr 05, 2005 1:33 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: After-Job Routine
Replies: 15
Views: 6569

madhonrougeuri wrote:I dont see the ExecDos in the Built-in before/after subroutines?why is it so?
Go to "Job properties" window and check Before-job subroutine After-job subroutine Drop down boxes.
by deepbanerji
Tue Apr 05, 2005 1:04 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: MQ
Replies: 0
Views: 679

MQ

I have a requirement that bulk xml files have to be zipped and put in MQ Queues. Is that possible to place a zip file in a Queue.
If so how can i do that.

Thanks in advance
by deepbanerji
Tue Mar 29, 2005 8:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installing MQ Series Plug In
Replies: 3
Views: 1490

Thanks. I guess, this is something DS administrator has to do. As a developer i dont have those previlages or access to root.
by deepbanerji
Mon Mar 28, 2005 3:35 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Installing MQ Series Plug In
Replies: 3
Views: 1490

Installing MQ Series Plug In

I am working on DS 7.5 and i have client installed on my machine. Server is some where else on Unix. Can somebody help me how to install the MQ Series Plug in.

Thanks,
Deep