Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Delimited Unload using IBM HPU

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2237
Location: @my desk

PostPosted: Wed Dec 01, 2010 11:52 am    Post subject: Delimited Unload using IBM HPU
Reply with quote

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? icon_rolleyes.gif
Back to top
View user's profile Send private message

Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2237
Location: @my desk

PostPosted: Tue Dec 07, 2010 5:30 pm    Post subject:
Reply with quote

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. icon_rolleyes.gif
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Dec 07, 2010 5:41 pm    Post subject:
Reply with quote

Arun,

are any of the 3 columns NULLABLE?
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2237
Location: @my desk

PostPosted: Tue Dec 07, 2010 5:48 pm    Post subject:
Reply with quote

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 icon_sad.gif
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Tue Dec 07, 2010 6:18 pm    Post subject:
Reply with quote

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
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2237
Location: @my desk

PostPosted: Wed Dec 08, 2010 8:32 pm    Post subject:
Reply with quote

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 icon_lol.gif )
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2237
Location: @my desk

PostPosted: Tue Dec 14, 2010 7:04 pm    Post subject:
Reply with quote

I had sent a note to IBM and they have tried to correct the example here.

http://www-01.ibm.com/support/docview.wss?uid=swg27017849

But it looks like they have the Results wrong this time icon_smile.gif . Anyways I have sent another note today.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Sort Card to Remove Duplicate records... raj4neo SYNCSORT 2 Wed Jan 25, 2017 4:44 am
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 6 Sun Nov 06, 2016 8:11 pm
No new posts To trim spaces in a pipe delimited da... Nish84 COBOL Programming 16 Mon Oct 10, 2016 1:54 pm
No new posts Best IMS DB Unload Utility jjabez10 IMS DB/DC 12 Thu Sep 22, 2016 11:15 pm
No new posts Format to pipe delimited with variabl... pshongal SYNCSORT 6 Wed Sep 14, 2016 2:48 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us