DSXchange

That is very simple job: Hierarchical stage -> Peek I didn't change any option of Hierarchical stage On Assemble: Overview - nothing to set here Input Step - nothing to set here REST Step General tab HTTP Method - Get Reusable connection - not used URL - my URL in form http://x.x.x.x:8080/UserManage...

How to call RESTful webservice with BASIC auth from DataStage? I tried to do it - specify BASIC auth in DataStage Hierarchical Stage but it does not send the header. I see in webservice log following: Starting testGet method... host = x.x.x.x:8080 connection = Keep-Alive user-agent = HTTP Step I try...

Hi I using Load db2 commad to fast delete all rows. That works for tables without any reference constraint (otherwise you will have to swich the check pending state for tables). You could issue the LOAD command from a sequence. the load coname could be: LOAD FROM /dev/null OF IXF MESSAGES /dev/null ...

As I wrote the lady can give file only in ebcdic or unicode.

Hi

Sorry... how I can use that?

Hi All I told about that file with woman who give me it. She said that it file in ebcdic. She can unload the data from mainframe database only in unicode and ebcdic. I understand that if I read the date in ASCII then file is ASCII file. But strange that DY_NUM_IN_WK = 5 (00 09) and DY_IN_EPOCH_NUM =...

2sudeepmantri

I done that. But I have don`t correct the DY_NUM_IN_WK (it equal 9 but should be 5), DY_IN_EPOCH_NUM (it equal -4216 but should be -21903) and date filed by ''. I define it as char 10.

Yes! You are rigth. I think I can read the data as ASCII. But datastage is not have the "data" type in CFF. How I can read the integer? I have some information about record: DAT_PER_KEY = 1 (00 00 00 01) DY_DT = 1940-01-12 (31 39 34 30 2D 30 31 2D 31 32 ) DY_NUM_IN_WK = 5 (00 09) DY_NUM_IN...

Hi

this is file from mainframe in ebcdic.

Hi, All I have file like that: 00 00 00 01 31 39 34 30 │ 2D 30 31 2D 31 32 00 09 ☺1940-01-12 ○ 00 00 00 0C 00 0C FF FF │ EF 88 00 1A 46 72 69 64 ♀ ♀яяп_ →Frid 61 79 20 20 20 46 72 69 │ 00 02 00 02 00 02 33 48 ay Fri ☻ ☻ ☻3H 31 39 34 30 2D 30 31 2D │ 31 32 31 39 34 30 2D 30 1940-01-121940-0 31 2D 31 ...

Hi All

Its integer type.

But I receive this error if I don`t use any transformation. Please help me.

Hi

I didn`t use any variables and any transformation. It`s very simple job like copy from source to destination table. But I planed use Transformer stage to transformation in my job.

Hi All I use simple job: db2_UDB_API--Transformer--sequence file. I have very strange compilation error :( Output from transformer compilation follows: ##I TFCN 000001 10:44:42(000) <main_program> Ascential DataStage(tm) Enterprise Edition 7.5.1A Copyright (c) 2004, 1997-2004 Ascential Software Corp...

sorry I don`t fined as I can delete my post

Hi All

Thank you for all.

2 DSguru2B:
I don`t must create and store any temporary data on database May be I can use something other?

2 bsreenu:
Hmm... Good idea. Are you mean job which store dataset in file in first point?