Search found 1724 matches

by priyadarshikunal
Fri Feb 08, 2008 3:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap allocation failed
Replies: 5
Views: 3615

Re: Heap allocation failed(Simple Correction )

... Call to malloc() failed to create BOR jump table /usr/lib/dld.sl: Not enough space malloc() is a UNIX routine that is used to get program working memory. Its a function of C that allocates memory dynamically to the program that calls it depending on the parameter passed Since the Unix kernel is...
by priyadarshikunal
Fri Feb 08, 2008 3:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Heap allocation failed
Replies: 5
Views: 3615

Re: Heap allocation failed(Simple Correction )

... Call to malloc() failed to create BOR jump table /usr/lib/dld.sl: Not enough space malloc() is a UNIX routine that is used to get program working memory. Its a function of C that allocates memory dynamically to the program that calls it depending on the parameter passed Since the Unix kernel is...
by priyadarshikunal
Tue Feb 05, 2008 12:17 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sqlldr error ...
Replies: 6
Views: 3788

Hi DS_FocusGroup, The sqlldr was founded, because in previous load insert 150000 records, when this number is increased the process abort ... Have you checked whether your log file is present or not check your configuration file, from there take the scratch space path. can you find the log file the...
by priyadarshikunal
Mon Feb 04, 2008 11:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot preserve the partitioning of the parallel data set
Replies: 10
Views: 5344

Thanks for the replies. Setting Clear for partitioning solves the fiorst problem. I checked the NLS section in the DS Administrator. It is set as ISO-8859-1. I tried to set it as OFF at the filter stage, but the job shows the same warning. Does setting NLS_LANG will resolve the issue? If so, what s...
by priyadarshikunal
Mon Feb 04, 2008 11:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot preserve the partitioning of the parallel data set
Replies: 10
Views: 5344

Thanks for the replies. Setting Clear for partitioning solves the fiorst problem. I checked the NLS section in the DS Administrator. It is set as ISO-8859-1. I tried to set it as OFF at the filter stage, but the job shows the same warning. Does setting NLS_LANG will resolve the issue? If so, what s...
by priyadarshikunal
Mon Feb 04, 2008 10:38 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cannot preserve the partitioning of the parallel data set
Replies: 10
Views: 5344

Re: Cannot preserve the partitioning of the parallel data se

Hi All, I'm facing an issue in my job. The job extracts data from an Oracle table (using Oracle Enterprise Stage) and a data set, does an outer join on the records from these and filters the records into 2 output sequential files (Exception records for each source) and a data set (Matching records ...
by priyadarshikunal
Fri Jan 25, 2008 9:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I find logs cleared by user from director? if yes how?
Replies: 8
Views: 2295

I suppose you could find that, yes, but not who cleared it. Use the standard 'DSGet' functions for the logs and search for 'Log cleared by user' as one of the events. ... I tried using DSGetLogEntry(JobHandle, DSJ.LOGANY) but I am getting a warning message Cannot get log event with id '99' and retr...
by priyadarshikunal
Fri Jan 25, 2008 9:48 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I find logs cleared by user from director? if yes how?
Replies: 8
Views: 2295

I suppose you could find that, yes, but not who cleared it. Use the standard 'DSGet' functions for the logs and search for 'Log cleared by user' as one of the events. ... I tried using DSGetLogEntry(JobHandle, DSJ.LOGANY) but I am getting a warning message Cannot get log event with id '99' and retr...
by priyadarshikunal
Fri Jan 25, 2008 8:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What is the difference between sequential file and Dataset
Replies: 3
Views: 2771

Re: What is the difference between sequential file and Datas

balu124 wrote:Hi ,
Can any one tell me the difference bet ween Sequential file and Dataset?
Can we delete the Dataset?Can we copy the Dataset?

try to hit the search button first before posting a new topic
by priyadarshikunal
Fri Jan 25, 2008 7:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Can I find logs cleared by user from director? if yes how?
Replies: 8
Views: 2295

Can I find logs cleared by user from director? if yes how?

Hi,

Can I find logs cleared by another user from director?

if yes how can i get that?


Regards,
by priyadarshikunal
Thu Jan 24, 2008 9:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: varchar to char coneversion
Replies: 11
Views: 5650

Re: varchar to char coneversion

first of all check for ascii value of that character

pass seq(PRODSTAT) to another link and check what result you are getting
by priyadarshikunal
Thu Jan 24, 2008 9:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: varchar to char coneversion
Replies: 11
Views: 5650

Re: varchar to char coneversion

Hi I am putting the constraints whatever you have suggested in Stage Variable and in downprocessing I am taking Not(StageVaraible) and in reject I am taking That Stagevariable... But you have declared that stage variable not nullable svNullCheckProdStat Setting null to this non-nullable field: Stag...
by priyadarshikunal
Thu Jan 24, 2008 9:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: varchar to char coneversion
Replies: 11
Views: 5650

Re: varchar to char coneversion

At compile time it generates error... reply with the error message. if you are trying to put that in transformer constraint then put it as IsNull(P_status) or seq(P_status)=32 can you find something from that code? Just analyze this ##W IIS-DSEE-TFEV-00025 14:51:45(010) <transform> Error when check...
by priyadarshikunal
Thu Jan 24, 2008 8:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: varchar to char coneversion
Replies: 11
Views: 5650

Re: varchar to char coneversion

priyadarshikunal wrote:
sanjumsm wrote:At compile time it generates error...
reply with the error message.

if you are trying to put that in transformer constraint then put it as
IsNull(P_status) or seq(P_status)=32
by priyadarshikunal
Thu Jan 24, 2008 8:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: varchar to char coneversion
Replies: 11
Views: 5650

Re: varchar to char coneversion

sanjumsm wrote:At compile time it generates error...
reply with the error message.