Search found 151 matches

by saraswati
Wed Jan 13, 2010 11:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to load a file from a URL using DataStage
Replies: 11
Views: 6414

Well since I do not have the Java Pack is there really no other way to load a file from a http url, like the WebServices Pack or etc?

Did anyone else faced sort or this requirement and fixed it. Please advise! Thanks in Advance!!
by saraswati
Wed Jan 13, 2010 6:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to load a file from a URL using DataStage
Replies: 11
Views: 6414

The problem is the web url: http://abc.com/group/files/file1 is not a FTP server but an HTTP one and hence we donot have a username/password to access it. Its like an intranet url where files are posted and is hosted on an apache server and you can download files from there. This is the reason I am ...
by saraswati
Wed Jan 13, 2010 6:15 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle 11g and DataStage 7.5 EE compatible?
Replies: 14
Views: 18292

As far as I remember from what IBM told me Oracle 11g might work with 7.5 versions but its certified to work with 8.0 and up only and hence if you face any issue with 11g and 7.5 IBM wont help us out.
by saraswati
Mon Jan 11, 2010 11:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to load a file from a URL using DataStage
Replies: 11
Views: 6414

By stage what stage do you mean?
by saraswati
Mon Jan 11, 2010 11:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to load a file from a URL using DataStage
Replies: 11
Views: 6414

How to load a file from a URL using DataStage

Hello friends, As per my requirement I need to read a file(say file1 as also depicted below in the url) which would be posted on a URL. The URL is somewha like: http://abc.com/group/files/file1 I need to use DataStage Jobs to do this. Kindly advise and let me know if I need to give further details. ...
by saraswati
Thu Dec 24, 2009 5:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: concatenate column value of different records in 1 record
Replies: 4
Views: 1812

Sort your data using a Sort stage and generate a Key Change column. (Better is to use three Sort stages to generate a "last in group" column.) Accumulate the long string in a stage variable, outputting every row (or, if you have it, when "last in group" occurs). Use a Remove Dup...
by saraswati
Thu Dec 24, 2009 1:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: concatenate column value of different records in 1 record
Replies: 4
Views: 1812

concatenate column value of different records in 1 record

Hi All, I have a requirement where I have to concatenate the column value of say N records and create one record out of it. For eg in the following sample data of 129 records, I have to combine the column JMTXLN based on the columns JMKCOO,JMDOCO,JMDCTO. This means my output will contain only 4 reco...
by saraswati
Thu Dec 17, 2009 4:56 am
Forum: General
Topic: problem in ABAP extract stage of SAP
Replies: 8
Views: 2601

could anyone give any thoughts...................
by saraswati
Wed Dec 16, 2009 6:17 am
Forum: General
Topic: problem in ABAP extract stage of SAP
Replies: 8
Views: 2601

yes i checked all things

the only difference is when all the information are hardcoded in the SAP stage, the jobs run


but when it is parameterized in the SAP stage, the compilation error comes...........

not able to find any idea why this is happening
by saraswati
Wed Dec 16, 2009 5:57 am
Forum: General
Topic: problem in ABAP extract stage of SAP
Replies: 8
Views: 2601

Sainath.Srinivasan wrote:Server name is one of the default properties provided during SAP logon.

You need to contact your SAP administrators about it.
But I can run and compile jobs if everything is hardcoded....i am facing it only when the things are parameterized......
by saraswati
Wed Dec 16, 2009 5:42 am
Forum: General
Topic: problem in ABAP extract stage of SAP
Replies: 8
Views: 2601

Sainath.Srinivasan wrote:Can you connect to SAP outside DataStage - something like logon pad ?

I can not connect to SAP outside DataStage.......only through ABAP extract stage i can do so.

please help......
by saraswati
Wed Dec 16, 2009 4:50 am
Forum: General
Topic: problem in ABAP extract stage of SAP
Replies: 8
Views: 2601

problem in ABAP extract stage of SAP

Hi all, I am facing a problem while extracting data from SAP tables. At first I am hard coding all the sap related parameters in the ABAP extract stage and generating the program for a particular SAP environment using the build SQL query as generation method. Now the compilation is done and the job ...
by saraswati
Thu Oct 22, 2009 4:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What are dmp files in DS Client path for?
Replies: 4
Views: 3676

What are dmp files in DS Client path for?

Hello Everyone,

We see many .dmp files created with the name : core_timestamp.dmp file in the path where our DataStage 8.1 client is installed :
E:\IBM\InformationServer\Clients\Classic

Please tell me what these files are for and how they are created.

regards,
Saraswati
by saraswati
Tue Sep 15, 2009 11:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic
Replies: 8
Views: 4668

i presume the last row to be : 100|BB1|50|52 instead of 100|BB1|51|52
by saraswati
Tue Sep 15, 2009 11:43 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Logic
Replies: 8
Views: 4668

i presume the last row to be : 100|BB1|50|52 instead of 100|BB1|51|52