DSXchange

Hello and thanks Arnd, Since the file still runing, the output of ANALYZE.FILE m_HFg2_6 STATS is giving me only lines of stars, see, i have one sequential file writing to six different hashed files at the same time (m_HFg2_1,.....,m_HFg2_6). keys are different also, ex. for m_HFg2_6: it has 5 column...

Hello guys; we have a requirement to load data for multiple dimensions in hashed files, the reason for that is, the records are not unique, so we get benfit of the hashed file primary key to overwrite. i have created 64BIT pathed hashed files, but to populate 6 files by 38Mil records, it takes more ...

Sorry,
i tried to help,
Graig, can i use the pivot stage, even the data to be splited contains in one column?

Hi Tracy; you can try this, use the field function and stage variable like this: 1. stage variable value eg StgV = [repeated part] eReplace( Field(YourCol,'|',1,2),'|',' ') = (09/09/2009 Tracy) 2. First column = StgV:' ':Field(YourCol,'|',3,1) 3. Second column = StgV:' ':Field(YourCol,'|',4,1) . . ....

Again thanks,
i will flag this as resolved

thanks again ArndW,

Why numbers?
if i stored, say 999 in integer(1), is it going to be stored correctly?

Thanks ArndW very much
that means i do not have to care about defining data types and length for my hashed files, anything will be acceptable am i right?

Hi All, Is there any difference in the file size of a hashed file, based on its columns datatype/length structure, i.e, HF1: col1 varchar(100)/char(100), col2 decimal(100)/integer(100)/numeric(100) HF2: col1 varchar(10)/char(10), col2 decimal(10)/integer(10)/numeric(10) HF3: col1 varchar(1)/char(1),...

Thank you very much all of you guys for your effort and time helping others.

we will contact IBM for this, and i will update you by the result as soon as we get it from them.

thanx again

Hello Arnd ;

This is the output:

RESIZE UV_SCHEMA * * *
Read operation failure. Read operation failure. RESIZE: Error on UV_SCHEMA. File not resized.

Hi; This is the output from resize: resize /ascential/Ascential/DataStage/DSEngine/sql/catalog/"UV_SCHEMA * * *" Usage: resize [-u] [-c] [-h | -x | -s [rows cols]] resize /ascential/Ascential/DataStage/DSEngine/sql/catalog/UV_SCHEMA * * * Usage: resize [-u] [-c] [-h | -x | -s [rows cols]]

Thanx Arnd,
It seems aim not lucky,

how can i resize the UV_SCHEMA? can you give me the command or guide.

thank you a lot for your effort with me.

Hello guys; i have run the command without brackets (3 times) and this is the output: $ fixtool -file /ascential/Ascential/DataStage/DSEngine/sql/catalog/UV_SCHEMA -level 5 -fix Filename: /ascential/Ascential/DataStage/DSEngine/sql/catalog/UV_SCHEMA Start Diagnostics. 0 Errors found in physical stru...

Hi ,

i will run it without brackets and post back the result after the weekend.i have no access on the server right now.



but if this the case, how this have done the fix for DS_JOBOBJECTS hashed file (with brackets)?

Aim using [-fix] as suggested by Ray and it has fixed the DS_JOBOBJECTS hashed file.

fixtool -file AW -level 5 [ -fix ]

shall i try it as you suggested "-fix" and is there any difference between them.

Kind regards