Search found 31 matches

by waklook
Sat Jan 26, 2008 2:09 am
Forum: Information Analyzer (formerly ProfileStage)
Topic: Run-time error '13': Type mismatch
Replies: 3
Views: 3658

Run-time error '13': Type mismatch

Hi every one; i install profileStage and it works fine on my computer, for some reason i unistall it and reinstall it again on the same machine , but when i try to run it(double click on it) , it gave's me this error : " Run-time error '13': Type mismatch " i unstall it and reinstall it se...
by waklook
Sat Dec 08, 2007 8:43 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: convert text format to binary format
Replies: 1
Views: 1035

convert text format to binary format

Hi guys,

we have requirement for converting normal text(flat) file into binary file format in our project,
how we can acheive that using datasatge.

we have searched the fourm but could not find any related stuff.

thanx in advance for your help

waklook
by waklook
Mon May 07, 2007 3:23 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is there any way to increase the inter stag rowbuffer?
Replies: 19
Views: 5373

Hi guys; Craig: this is what happen with me when i run the job for only 10,000 xml file: using the old job using 'XML DOCUMENT' option and using your advise 'URL/FILE PATH' the load time was very close (arount 52Min),so i tryed using LinkPart&LinkColl with 8 shared Containers(containing only the...
by waklook
Sun May 06, 2007 8:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is there any way to increase the inter stag rowbuffer?
Replies: 19
Views: 5373

Hi,

Craig:
for using the URL / File path option i missed to choose YES for fully qualified option in folder stage, now it's working,
regarding your advise i'm going to do that and i will let you all know the result.

thanks guys.
by waklook
Sun May 06, 2007 1:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is there any way to increase the inter stag rowbuffer?
Replies: 19
Views: 5373

Hi; thanks Ray and Craig and sorry for short, i posted this problem before with the job desc, and what i'm trying to do is according to Ernie advise (thanks Ernie), and i have exactly this error, so i sked according to that error. Craig: i have tryed the URL/File path but it does't work with me, and...
by waklook
Sat May 05, 2007 2:09 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is there any way to increase the inter stag rowbuffer?
Replies: 19
Views: 5373

Hi, thanks to all of you guys for your replys, i have xml files with max size around 20mb, when i use the link partitioner and link collector i have to activate the inter process rowbuffer, at this point it will move every file as one record and bcz the file is too big(row) i have that error,may be ...
by waklook
Wed May 02, 2007 8:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is there any way to increase the inter stag rowbuffer?
Replies: 19
Views: 5373

Sorry guys i'm not making these sizes up? i have realy 17,296kb file size and many files that are more than 15,000kb and the size increases litle bit every load.(monthly). i know about Kumar answer , the max size availble is 1024kb , i'm only asking if there any other solution. sorry if i did or sai...
by waklook
Wed May 02, 2007 6:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is there any way to increase the inter stag rowbuffer?
Replies: 19
Views: 5373

Hi again

Ray

say it's 5mb how can i do that?
by waklook
Wed May 02, 2007 2:03 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: is there any way to increase the inter stag rowbuffer?
Replies: 19
Views: 5373

is there any way to increase the inter stag rowbuffer?

Hi, i have this error while activating inter process rowbuffer, " row too big for inter stage rowbuffer ", i searched the forum but it did not solved my problem. my ques is how can i increase the roubuffer size to 20mb, bcz my row size is like 20mb, is there any setting or configration i c...
by waklook
Mon Feb 12, 2007 6:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xml stage and pivot stage takes most of the job time
Replies: 4
Views: 1459

Thanks Craig and Ernie

Hi Guys thanks alot Craig and Ernie, this is little info about our system, the server is HP-UNIX 11.11 with 8 CPUs,the clients are WinXp, i also have some correction on the flow: 22H between FolderStage --> transformerStage --> XML inputStage --> transformerStage --> SequentialFile , by mean pivotSt...
by waklook
Sun Feb 11, 2007 7:07 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: xml stage and pivot stage takes most of the job time
Replies: 4
Views: 1459

xml stage and pivot stage takes most of the job time

Hi Guys, we implemented server job like this: FolderStage -->transformerStage --> XML inputStage --> transformerStage --> PivotStage --> SequentialFiles + other transformerStages and SequentialFiles the number of xml files around 500,000 per load,and the max file size <5MB , it takes around 24H to l...
by waklook
Sat Feb 10, 2007 7:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Client DLL error
Replies: 1
Views: 1038

Client DLL error

Greetings, One of our clients are getting the following error message when trying to import a text file definition using the sequential file stage: "Runtime error 374 failed to activate control vb.usercontrol." We have tried re-installing the client twice but the problem still exists. In t...
by waklook
Sun Dec 17, 2006 5:21 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder stage to xml stage
Replies: 1
Views: 737

Folder stage to xml stage

Hi all, I'm using folder stage to extract multiple xml files from some directory in unix server , i have this error coming up, "XmlFoldrTEst..Folder_0.: DSD_DIROpen Failed to set NLS map MS1252-CS on directory /invoice/NOV_Invoice." by the way i change the NLS to many other including "...
by waklook
Sun Dec 17, 2006 1:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder stage to xml stage
Replies: 1
Views: 835

Folder stage to xml stage

Hi all, I'm using folder stage to extract multiple xml files from some directory in unix server , i have this error coming up, "XmlFoldrTEst..Folder_0.: DSD_DIROpen Failed to set NLS map MS1252-CS on directory /invoice/NOV_Invoice." by the way i change the NLS to many other including "...
by waklook
Sun Nov 12, 2006 6:54 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Error calling DSRunJob(JOB NAME), code=-14
Replies: 3
Views: 2253

Thanx alot chulett,

I searched the forums and i found what i'm looking for.

thanks again