| View previous topic :: View next topic |
| Author |
Message |
schintala
Beginner
Joined: 18 May 2005
Posts: 108
Topics: 31
Location: USA
|
 Posted: Mon Apr 05, 2010 4:42 pm Post subject: Platinum Fastunload |
 |
|
Hi,
I was trying to unload data from Image Copy of a table using platinum fast unload util. I got the below error Did anybody have any clue? Not sure for an image copy input format, does the conversion allows from varchar to char.
| Code: |
FASTUNLOAD
DISPLAY-STATUS 1000000,T
INPUT-FORMAT IMAGECOPY
DATE-FORMAT ISO
IO-BUFFERS 60
LOAD-CONTROL DB2LOAD
OUTPUT-FORMAT EXTERNAL
SHRLEVEL IGNORE
SORTSIZE 8M
SORTNUM 6
ESTIMATED-ROWS 10000000
SELECT
PRTN_VLU_NO ,
PYMNT_ID ,
PAY_AGT_ID ,
PAY_RPT_TSTMP ,
PAY_RPT_TAG_NO ,
PAY_DTL_BTC_SEQ_NO ,
PAY_LN_TAG_NO ,
PAY_MULTI_TXN_CD ,
DATA_SRC_CD ,
UNIT_OFC_ID ,
BLLR_ID ,
TXN_SRC_CD ,
SUBSTR(CLNT_TXN_NO,1,30)
FROM PSSDBAP.PSIPAYT
WHERE PRTN_VLU_NO = 3
ORDER BY "PRTN_VLU_NO", "PAY_AGT_ID", "PAY_RPT_TSTMP"
;
|
I was trying to convert the column CLNT_TXN_NO from Varchar(30) to Char(30) to enable me to load the file on Linux server. Any ideas. Able to unload without SUBSTR. My error as follows.
| Code: |
PFU0077E - FORMAT ERROR IN SPECIFICATION OF COLUMN NAME -
MAX SIZE=18, MIN SIZE=1
SUBSTR(CLNT_TXN_NO,1,30)
1...5....10...15...20...25...30...35...40...45...50...55...60...65...70...75
PFU0011E - SYNTAX ERROR ON OR NEAR LOCATION 008
PFU0075E - INVALID SELECT STATEMENT - SEE DOCUMENTATION
|
|
|
| Back to top |
|
 |
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12380
Topics: 75
Location: San Jose
|
| Posted: Mon Apr 05, 2010 5:11 pm Post subject: |
|
|
schintala,
Isn't it a clear issue ? how is CLNT_TXN_NO defined? does it have 30 bytes? looks like it is only 18 bytes at max.
Correct the following statement to use CHAR
CHAR(CLNT_TXN_NO)
kolusu
Last edited by kolusu on Mon Apr 05, 2010 7:41 pm; edited 1 time in total |
|
| Back to top |
|
|
schintala
Beginner
Joined: 18 May 2005
Posts: 108
Topics: 31
Location: USA
|
| Posted: Mon Apr 05, 2010 5:29 pm Post subject: |
|
|
Kolusu,
Thank you so much for the quick reply. No luck. It gives same error message. It complaing about the column name of 18 bytes max.
| Code: |
PFU0077E - FORMAT ERROR IN SPECIFICATION OF COLUMN NAME -
MAX SIZE=18, MIN SIZE=1
CHAR(CLNT_TXN_NO,1,30)
1...5....10...15...20...25...30...35...40...45...50...55...60...65...70...75
PFU0011E - SYNTAX ERROR ON OR NEAR LOCATION 006
PFU0075E - INVALID SELECT STATEMENT - SEE DOCUMENTATION
|
|
|
| Back to top |
|
|
papadi
Supermod
Joined: 20 Oct 2009
Posts: 594
Topics: 1
|
| Posted: Mon Apr 05, 2010 6:19 pm Post subject: |
|
|
Possibly i am missing something. . .
How does one use 30 bytes of an 18-byte value?
_________________
All the best,
di |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12380
Topics: 75
Location: San Jose
|
| Posted: Mon Apr 05, 2010 7:40 pm Post subject: |
|
|
schintala,
Yikes ! I made a mistake with the CHAR function syntax . Sorry about that. It should be just
My only guess is that you spelled the name of the column wrong and the utility assumed the whole thing as a single column name and is complaining about the length of the column name exceeding 18 characters. Make sure that you have the right column name
Kolusu |
|
| Back to top |
|
|
schintala
Beginner
Joined: 18 May 2005
Posts: 108
Topics: 31
Location: USA
|
| Posted: Tue Apr 06, 2010 9:14 am Post subject: |
|
|
Kolusu,
Looks like platinum fastunload utility for input-format with Image Copy not able to recognize to convert the column from one data type to another. I tried with your suggestion it still gives same result. Thank you for your time. I'll keep posted for the benifit of others if I found any solution.
Thanks |
|
| Back to top |
|
|
jim haire
Beginner
Joined: 30 Dec 2002
Posts: 140
Topics: 40
|
| Posted: Tue Apr 06, 2010 1:56 pm Post subject: |
|
|
| Try Table as the Input-Format instead of Imagecopy. |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
