DSXchange

Hi,

How to find out which job is creating a particular hash file?

Thanks.

In my job design i have one source(hash file) and 1 lookups( hash file). When i find a value in lookup as A1 then i need to concatenate the value coming from source with 1 and hook that value When i find a value in lookup as A2 then i need to concatenate the value coming from source with 2 and hook ...

I AM GETTING DATA FROM MAINFRAME AND WRITING DATA TO SEQUENTIAL FILE. WHEN I AM WRITING DATA TO SEQ FILE I AM GETTING SOME SPACES AT THE END. SO I USED A TRIMFA(TRIMB(FIELD)) BUT STILL I HAVE THE SAME PROB. I TRIED ALL OPTIONS WITH TRIM. EXAMPLE. 213107850 ANY IDEAS. THANKS IN ADVANCE. Only for rea...

I AM GETTING DATA FROM MAINFRAME AND WRITING DATA TO SEQUENTIAL FILE. WHEN I AM WRITING DATA TO SEQ FILE I AM GETTING SOME SPACES AT THE END. SO I USED A TRIMFA(TRIMB(FIELD)) BUT STILL I HAVE THE SAME PROB. I TRIED ALL OPTIONS WITH TRIM. EXAMPLE. 213107850 ANY IDEAS. THANKS IN ADVANCE. THERE ARE SP...

I AM GETTING DATA FROM MAINFRAME AND WRITING DATA TO SEQUENTIAL FILE. WHEN I AM WRITING DATA TO SEQ FILE I AM GETTING SOME SPACES AT THE END. SO I USED A TRIMFA(TRIMB(FIELD)) BUT STILL I HAVE THE SAME PROB. I TRIED ALL OPTIONS WITH TRIM. EXAMPLE. 213107850 ANY IDEAS. THANKS IN ADVANCE. THERE ARE BO...

I AM GETTING DATA FROM MAINFRAME AND WRITING DATA TO SEQUENTIAL FILE. WHEN I AM WRITING DATA TO SEQ FILE I AM GETTING SOME SPACES AT THE END. SO I USED A TRIMFA(TRIMB(FIELD)) BUT STILL I HAVE THE SAME PROB. I TRIED ALL OPTIONS WITH TRIM. EXAMPLE. 213107850 ANY IDEAS. THANKS IN ADVANCE. SQL TYPE IS ...

I AM GETTING DATA FROM MAINFRAME AND WRITING DATA TO SEQUENTIAL FILE.

WHEN I AM WRITING DATA TO SEQ FILE I AM GETTING SOME SPACES AT THE END.

SO I USED A TRIMFA(TRIMB(FIELD)) BUT STILL I HAVE THE SAME PROB.

I TRIED ALL OPTIONS WITH TRIM.

EXAMPLE.

213107850

ANY IDEAS.

THANKS IN ADVANCE.

Hi, when i am performing a lookup i am getting this error, job design is odbc | odbc----->lkp------>target I am getting the following error: LKP,0: When binding input interface field "xyz" to field "xyz": Converting nullable source to non-nullable result; fatal runtime error coul...

HI,

when i am writing data to file set, i am getting the following warning

"when checking operator: No nodes with disk in "export" resource pool; using default disk pool instead.

Any idea how to solve this.

Thanks in advance

HI,

when i am trying to write data to a sequential file i am gettinng warnings.

"Exporting nullable field without null handling properties"

Any suggestions.

Thanks.

Hi,

when i am using a oracle enterprise stage i am getting the following error:

"Access to sys.dba_extents required but not available. please see the your dba for select privileges"

how to resolve this issue.

thanks in advance

Hi,

Source data contains 007 when i write to a xls file i am getting the same value.

But when i mail the file as an attachment. when i open the attachment i am able to see only 7 but not 007.

I want to retain the 00.

Any ideas.

Thanks.