Search found 48 matches

by venugopal81
Thu Aug 11, 2005 12:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to search a string and concatenate
Replies: 5
Views: 1797

Parallel job

parallel Job
roy wrote:Hi,
the answer depends on the server or parallel question Craig asked you.
So which job type do you need it for?
by venugopal81
Wed Aug 10, 2005 2:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to search a string and concatenate
Replies: 5
Views: 1797

How to swap it arount to the front

swap it around to the front.
Please tell me how to swap the values in datastage.
by venugopal81
Tue Aug 09, 2005 9:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to search a string and concatenate
Replies: 5
Views: 1797

how to search a string and concatenate

Hi all,

I need search for the character '-' in the last position if the last position is '-' then move it to the front of the number.

Thanks & regards
venu
by venugopal81
Mon Aug 08, 2005 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Update existing or insert new rows
Replies: 4
Views: 1507

Update existing or insert new rows

Hi All,

We have extracted data from SAP-BW and loaded data in to DB2 database server. We using update existing or insert new rows option.
But problem is records or not updated, but records inserted.

Can you please suggest me on this....

Thanks & regards
venu
by venugopal81
Wed Aug 03, 2005 3:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Not getting Negitive balances in sas dataset
Replies: 2
Views: 793

Not getting Negitive balances in sas dataset

I have changed current_bal field from varchar to numeric. Because I need to shown the negative balances in SAS. But, some of the records are rejected and shown this warrning message. Field 0: Import warning at record 21592: "Current_Bal" has import error and no default value; data: {1 0 0 ...
by venugopal81
Thu Jun 23, 2005 8:14 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Where the Log files stored?
Replies: 3
Views: 1241

Where the Log files stored?

How can i find my 10 days old Log. Job generates 100s of Logs..
Where we can get complete LOG Information.
by venugopal81
Thu Jun 23, 2005 8:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Load Pack for SAP BW Scheduling Issue.
Replies: 2
Views: 875

Load Pack for SAP BW Scheduling Issue.

Hi All, I am using Load pack for SAP BW as target. Issue: I can able to Load the data into SAP BW manually using Load pack. If I scheduled the Job the Job is getting hanged at NEWJOB_BWPLOAD..Load_PACK_for_SAP_BW_62: InfoPackage ZPAK_3XI2PYAZABFBSI9X098BRL5PP started with request id of REQU_3Y7NTU41...
by venugopal81
Tue Jun 21, 2005 11:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How can i find which datastage Job FTP file to REmote server
Replies: 2
Views: 1000

How can i find which datastage Job FTP file to REmote server

How can i find which datastage Job FTP file to REmote server. Which i can't find in datastage. I couldn't find a datastage job that run in production. In my production server datastage job ftp the file in to SAP server. Now file in the SAP server is 2472735 Jun 21 00:40 CIS-OP-ORDERS.TXT . But i cou...
by venugopal81
Tue Jun 21, 2005 11:47 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How can i find which Datastage Job sends file to Remote serv
Replies: 1
Views: 1004

How can i find which Datastage Job sends file to Remote serv

How can i find which datastage Job FTP file to REmote server. Which i can't find in datastage. I couldn't find a datastage job that run in production. In my production server datastage job ftp the file in to SAP server. Now file in the SAP server is 2472735 Jun 21 00:40 CIS-OP-ORDERS.TXT . But i cou...
by venugopal81
Fri May 06, 2005 4:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: what is the purpose of metabroker?
Replies: 1
Views: 1101

what is the purpose of metabroker?

By Importing and Exporting we have datastage manager. What is the main advantage using metabroker.

thanks
venu
by venugopal81
Wed May 04, 2005 3:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to run job in DataStage Director (Urgent)
Replies: 8
Views: 3657

Now successfuly running

ArndW,

I cleaned registry and installed again. Now it successfuly running.

thanks ArndW

thanks & regards
venu
ArndW wrote:Venu,

if it worked before and now does not ... re-install.

De-install and make sure your registry is cleaned up of extraneous Ascential entries.
by venugopal81
Tue May 03, 2005 8:10 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Hashed File Calculator
Replies: 8
Views: 3438

Which hashed file gives good performance

Arndw, Which hashed file good performance. Static/Dynamic. There is two dynamic hashed files. GENERAL or SEQ.NUM hashing algorithms. can you differentiate these two. thanks venu Venu, There are several different types of hashed files, the two main categories are dynamic and static. Dynamic files, as...
by venugopal81
Tue May 03, 2005 7:51 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to run job in DataStage Director (Urgent)
Replies: 8
Views: 3657

What you said is correct

ArndW, Exactly what you said happend when i am working with datastage. What is the solution for that (i reinstalled) . Is it OS problem? Any suggestions. thanks venu Venu, yes, you have an installation problem. I don't know what it is, but all the symptoms are there. Are your Server and Client machi...
by venugopal81
Tue May 03, 2005 7:45 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Datastage Hashed File Calculator
Replies: 8
Views: 3438

Datastage Hashed File Calculator

Hi All,


What is the purpose of Datastage Hashed File Calculator.

Please provide me detail information about DHFC.


thanks & regards
venu
by venugopal81
Tue May 03, 2005 7:26 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Unable to run job in DataStage Director (Urgent)
Replies: 8
Views: 3657

Re: Restart(Close u r section) DataStage

Hi Hexa,

I restarted and tried many times. I done reinstallation also. But i can't.
hexa wrote:May be restart(close) u r datastage and try.
:wink:
thanks & regards
venu