|
View previous topic :: View next topic
|
| Author |
Message |
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
Hello all,
I was just trying to do a delimited unload using IBM HPU 3.2 utility. While doing that I just came across an example given in the IBM manual which made me confused and hence opened a thread on this,
As per my understanding, FORMAT DELIMITED has three subparameters,
SEP - specifies the field separator character.
DELIM - specifies the character by which each field has to be enclosed.
NULL DELIM - On mentioning this, NULLs will NOT be enclosed by the DELIM character.
Page 177 of the HPU 3.2 User guide has the below example.
| Quote: |
The table in the following figure shows the results of different settings for a row that contains three columns that have the following character values:
| Code: |
Col 1 BEGINNING (varchar)
Col 2 empty (varchar)
Col 3 END (char 3) |
Table 17.
Results of selected DELIMITED block keyword settings
| Code: |
DELIMITED block setting Result
-------------------------- ------
SEP ';' BEGINNING;;;END
SEP';' DELIM '/' /BEGINNING/;//;//;/END/
SEP';' DELIM '/' NULL DELIM /BEGINNING/;;//;/END/ |
|
The number of columns is three, but the result in the example looks like that of a SELECT from four columns.
Am I missing something here?  |
|
| Back to top |
|
 |
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
Hello all,
Does anybody who has access to IBM DB2 HPU, feel that there's a small correction required in the manual?
Or is it my misunderstanding. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
Arun,
are any of the 3 columns NULLABLE? |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
Hi Dick,
Thanks for your response.
The Quote is a portion of an example given in the manual. It does not say anything about the column NULL attributes. What I feel is, there should have been 4 columns in the table with Col2 having a NULL and Col2 and Col3 should be Col3 and Col4 respectively. Did I confuse it altogether  |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
ok,
explain it, i can not.
i would run tests of rows, 3 columns, and swap empty between col1 and col2
then look at the output.
i have not found many problems with IBM manuals that are not corrected within 6 months and the Build Date: 02/25/10 is long ago.
I would search IBM developerworks for HPU and see if there is a reference.
without running the test that I described above, i would tend to think that it was I and not them, that is confused.
But, if after running the test
(and remember to alternate empty/null between COL1 and COL2)
I still had no idea what IBM was talking about, would ask them.
I would also suggest sending Kolusu a PM. |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
|
|
Hi Dick,
I will post the results from the test, but if you look at the columns in the result given, it looks like there are 4 columns in the result set and this is where it goes against the 3-column table example it started with.
PS. Anyways it's nothing major or it seems like nobody is impacted(except me  ) |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2481
Location: @my desk
|
|
| Back to top |
|
|
|
|
. Anyways I have sent another note today.