DSXchange: DataStage and IBM Websphere Data Integration Forum
Search found 393 matches
Author Message
 Topic: Can't read Variable Block Mainframe file
pradkumar

Replies: 7
Views: 4160

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Dec 24, 2012 11:15 am   Subject: Can't read Variable Block Mainframe file
Merry Chrismas everyone.

I still have some problem on this one with an additional question:

I was told in Variable Block mainframe file, in the beginning of each record, there is a record prefix ...
 Topic: Can't read Variable Block Mainframe file
pradkumar

Replies: 7
Views: 4160

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Dec 08, 2012 9:51 am   Subject: Can't read Variable Block Mainframe file
Yes, Craig. I have read the FAQ and also searched in forum about Mainframe and COBOL before I posted this. Although I learned a lot from that, i still can't figure out my problem.

In FAQ, it says m ...
 Topic: Can't read Variable Block Mainframe file
pradkumar

Replies: 7
Views: 4160

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sat Dec 08, 2012 8:32 am   Subject: Can't read Variable Block Mainframe file
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi All,

I am new to COBOL and I have been struggling for a week. I have a Variable Block file and 3 copybooks (header, detail and trailer) from our Mainframe guy. The record length in Mainframe sh ...
 Topic: Trying to understand job score (1)
pradkumar

Replies: 11
Views: 6875

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon Aug 20, 2012 11:23 am   Subject: Trying to understand job score (1)
Hi all,

Hope someone can give some advice, thanks in advance.

1) How many nodes defined in the config file? 4 or 5? Is there a conductor node?
2) For SMP do we need a conductor node?
3)Is ther ...
 Topic: Read XML File - Size limitation
pradkumar

Replies: 3
Views: 1860

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Mon May 17, 2010 9:19 am   Subject: Read XML File - Size limitation
Hi ,

Thanks for your response.

Yes im talking about Kilobytes's only not Megabytes.Thats weird.

Do i have to do any changes in the job design and properties?
 Topic: Read XML File - Size limitation
pradkumar

Replies: 3
Views: 1860

PostForum: IBM® Infosphere DataStage Server Edition   Posted: Fri May 14, 2010 10:42 am   Subject: Read XML File - Size limitation
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi Gurus,

I have searched the forum before posting the question and found many anwers to some of the issues iam having in reading the xml files. But i have one outstanding issue with my requirement ...
 Topic: DataType Conversion -- Compilation Error
pradkumar

Replies: 1
Views: 754

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu May 13, 2010 10:08 am   Subject: DataType Conversion -- Compilation Error
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi All,

I have job which pulls the data from file using CFF stage and loads into a dataset.CFF stage has 2 columns and their datatypes defined as below
1) ID - Char(20)
2) Date -Decimal (9,2) -- ...
 Topic: Need help in building the logic
pradkumar

Replies: 3
Views: 1420

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Wed May 05, 2010 10:36 am   Subject: Need help in building the logic
Thanks for your reponses. I will try these options and let you know if i get any issues.
 Topic: Need help in building the logic
pradkumar

Replies: 3
Views: 1420

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue May 04, 2010 9:39 am   Subject: Need help in building the logic
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi Everyone,

I have a requirement to run the ds job for each year/month combination, beginning 5 years in the past and continuing until up to last month, and insert the dates into SQL as format YYY ...
 Topic: Change the host name of the repository
pradkumar

Replies: 1
Views: 1189

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Mon May 03, 2010 3:00 pm   Subject: Change the host name of the repository
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi

I am new to the DS 8.1. I installed DS few days back but the instance on which metadata repository was built is moved to new hos ...
Resolved
 Topic: IBM Information Server DS 8.1
pradkumar

Replies: 1
Views: 1330

PostForum: General   Posted: Tue Apr 27, 2010 3:16 pm   Subject: IBM Information Server DS 8.1
DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hey

I am a new to DS 8.1. I am having few basic questons on architecture.

1) Does the WAS has to be up and running always for the DS jobs to run on DS Engine.

2) Does metadata repository stor ...
 Topic: Heap Allocation Error with XML output stage
pradkumar

Replies: 10
Views: 7441

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Tue Apr 20, 2010 12:43 pm   Subject: Heap Allocation Error with XML output stage
Hi,

I introduced a new column and using the function @inrownum/10(Test purpose) for that field and running the transformer sequentially to make sure all the source records process to one node . And ...
 Topic: Heap Allocation Error with XML output stage
pradkumar

Replies: 10
Views: 7441

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Apr 18, 2010 1:47 pm   Subject: Heap Allocation Error with XML output stage
Thanks for the response. I dont think i can use the columns that are passing from the source. So i need to introduce a new column in the transformer and use the new column as trigger option. But the q ...
 Topic: Heap Allocation Error with XML output stage
pradkumar

Replies: 10
Views: 7441

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Sun Apr 18, 2010 11:02 am   Subject: Heap Allocation Error with XML output stage
Hi All,

Thanks for your responses.

Other than writing a custom code to create a xml file,could anyone let me know is there a way to create around 500k records as one xml file with the same struc ...
Resolved
 Topic: Concatination not working
pradkumar

Replies: 6
Views: 2007

PostForum: IBM® DataStage Enterprise Edition (Formerly Parallel Extender/PX)   Posted: Thu Apr 15, 2010 9:04 am   Subject: Concatination not working
Hi Ray,

I found the reason for the issue. Out of 12 fields one of the field is of char datatype of length 10. But in the source sql iam doing substr [4,7]. So when i changed the length of the field ...
 

 Jump to:   



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours