Search found 50 matches

by pillip
Fri May 28, 2010 2:16 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML File size limit
Replies: 10
Views: 7498

I am using XML output stage to create XMLs. For 100 MB what would be the approximate count of the records which can be put in it.


Thanks
by pillip
Fri May 28, 2010 1:33 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML File size limit
Replies: 10
Views: 7498

XML File size limit

Hi,

Do we have any limit on the size of the XML file which can be written from Datastage.


Thanks,
Prasanna
by pillip
Fri May 28, 2010 4:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Embed XML in another XML
Replies: 6
Views: 2605

i have used the transformer after the first xml and concatenated start and end tags. But the output is getting truncated. Can you advise on how to use another XML output stage. The output of the first xml is an XML dataelement. Now I need to append start and end tags to it. What Xpath expressions do...
by pillip
Thu May 27, 2010 3:20 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Embed XML in another XML
Replies: 6
Views: 2605

Embed XML in another XML

i want to embed one xml into another. I have been successful in creating the first xml by using '/' in the XML output stage. I put this in the sequential file and the xml got created fine. Now I want to embed this xml in start and end tags. I used another xml output stage, but was unable to get the ...
by pillip
Thu May 27, 2010 2:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with XML job
Replies: 34
Views: 12734

I have a similar issue , i want to embed one xml into another. I have been successful in creating the first xml by using '/'. I put this in the sequential file and the xml got created fine. Now I want to embed this xml in start and end tags. I used another xml output stage, but was unable to get the...
by pillip
Thu May 27, 2010 2:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with XML job
Replies: 34
Views: 12734

I have a similar issue , i want to embed one xml into another. I have been successful in creating the first xml by using '/'. I put this in the sequential file and the xml got created fine. Now I want to embed this xml in start and end tags. I used another xml output stage, but was unable to get the...
by pillip
Thu May 27, 2010 10:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concatening XML lines into one chunk
Replies: 7
Views: 2419

Concatenating XML lines into chunk.

I have a similar issue. I have used the output XML column as '/' (root) to make an XML chunk and then used a transformer to concatenate this with the start and end tags. Used another XML output stage. But still i am unable to get the required output. This is what i m expecting <Start tag> XML Chunk ...
by pillip
Thu Mar 25, 2010 1:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Splitting XML files
Replies: 1
Views: 1098

Splitting XML files

Hi,

Do we have a way of splitting XML files based on a record count.

We use XML output stage for creating XML. Do we have any option to split the output file based on record count.


Thanks.
by pillip
Tue Mar 09, 2010 9:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ABAP stage and SIGINT error
Replies: 1
Views: 983

ABAP stage and SIGINT error

Hi, We are getting SIGINT error when data is being extracted from the ABAP extract stage. This is not intermittent. But, As of late we have been facing this problem quite frequently. There is a warning which we get in the ABAP stage processing. Is this the reason for this error? Thanks and Regards, ...
by pillip
Tue Mar 02, 2010 11:05 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Datastage Version Control
Replies: 4
Views: 4642

Datastage Version Control

Hi,

Do we have any datastage version control tool where we can keep track of the versions of a particular job.
This will be really helpful in development when there are a many people working on the releases.
Do we have any scope of having this in the future.


Thanks.
by pillip
Tue Jan 26, 2010 2:51 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ORA-00060: deadlock detected while waiting for resourc
Replies: 3
Views: 2626

ORA-00060: deadlock detected while waiting for resourc

Hi,

I am getting the following error when data is getting upserted into the table in the oracle stage.

Kindly let me know what could be the issue.

I have checked that there are no locks on the table. Seems that there are table level locks on the table.

Thanks,
Prasanna
by pillip
Fri Jan 15, 2010 9:55 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ABAP Extract stage - Chinese and Latin characters
Replies: 4
Views: 2070

I have tried with GB2312 and BIG5 but still not able to get them.




Thanks.
by pillip
Thu Jan 14, 2010 10:50 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: ABAP Extract stage - Chinese and Latin characters
Replies: 4
Views: 2070

ABAP Extract stage - Chinese and Latin characters

Hi, We have Chinese and Latin characters in one field in the SAP source system. We have used the NLS settings as UTF-8 in the ABAP extract stage to retrieve the data. But the data is converted into junk characters. Could you please let us know what NLS settings need to be used for getting the chines...
by pillip
Tue Dec 15, 2009 11:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Path for dsdesign on client machine
Replies: 10
Views: 3798

ray.wurlod wrote:Does the /SAVE_AS_BITMAP option work for you? ...
Hi,

The option /SAVE_AS_BITMAP opens up the designer.

Please help

Thanks.
by pillip
Sun Dec 13, 2009 11:18 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Path for dsdesign on client machine
Replies: 10
Views: 3798

Hi Ray, Could you please help. Thanks, Prasanna Hi, I have used the following syntax for dsdesign and executed the same from the location C:\IBM\InformationServer\Clients\Classic dsdesign.exe /H=<hostname> /U=<user> /P=<password> /R /RP="C:\Documents and Settings\Alice\My Documents\Job_Reports&...