DSXchange

I had gone through the documents, and developed a sample job. But it is aborting due to the following reason. I searched the site for this error but in didnot result anything. main_program: Fatal Error: Fatal: Shared library (pivotenu.so) failed to load: errno = (2), system message = (/opt/IBM/Ascen...

Got it in docs.

Thanks
Kavuri

Hi, I never used pivot stage. I am trying how to use this. Here below I took a sample scenario. Input file: 11,22,33,44,55 I defined the schema as a INTEGER b INTEGER c INTEGER d INTEGER e INTEGER Now I am trying to pivot this so that I can get 5 rows in one column. I studied in our forum that we ne...

I am using partial schema, something like below. record{ intact=details, record_delim_string='\n'} ( Store:string[1] {delim=none}; Store_ID: string[5] {delim=none}; Day: string[10] {delim=none}; Trans_Count: string[5] {delim=none}; DOL: string[] {delim=none}; ) In the input file I wont get first fie...

Hi George,
My input records are coming somtimes with 4 fields and sometimes with 5 fields. So can you tell me how we can resolve this in the partial schemas.

Thanks
Kavuri

Hi,
I am having a schema file. It contains 5 fields. Input files what I am having are sometimes 5 fields and sometimes only 4 fields are there.

In this case Is there any way to parse one field with a default value in the schema file.

Thanks
Kavuri

I had compiled the code I got only warnings as below. findrecord.cpp: In function `char* findrecord(char*, char*)': findrecord.cpp:17: warning: address of local variable `record' returned findrecord.cpp:17: warning: address of local variable `record' returned Please let me know if I am doing any wro...

Hi, I had written a small programme for formatting my input data. I had created the object file for it. I had created a parallel routine in the manager with the following arguments. RoutineName: findrecord Type:External Function External Subroutinename: findrecord.o LibrarayPath:XXXXXXXX/XXXXXX/XXXX...

Hi, I am getting different formatted files like comma seperated, continuos length, pipe delimited etc. All are having data not in the same order. I want to read this data and do the necessary modifications and need to write into a common database table or file. Below are some examples of data. I don...

Hi,
Can anybody tell me what is the following warning and how I can eliminate this?

Failed to connect to JobMonApp on port 13401.

Thanks
Kavuri

Hi,
We resolved it.

This issue is resolved now. The problem was , in DataStage Administrator -> Projects -> Properties --> Environment - > Paralel - > Reporting ,:
set the variable APT_RECORD_COUNTS to 'True'.


Thanks
Kavuri

Hi, I am working to find the linkrow count for this I am using the following command. I am able to fetch the rowcount on one server and unable to do the same on the other server. I am not getting any error but it is resulting 0 rows. I checked the file, it is populated with some data in it. This is ...

ArndW,
same problem. We thought it might be a problem with space and we cleared some space also.

Thanks
Bhargava

Hi ArndW,
we are using Netezza database. Here below is a snapshot.


Thanks
Kavuri

ArndW wrote:After the job aborts with 139, do a reset in the director and see if you get a message titled "From previous run..."

No ArndW,
There is no message like that. It simply says
Resetting Job test_copy_table.
Job test_copy_table has been reset.

Thanks
Kavuri