IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to insert a lengthy string having ',. into a DB2


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vidyaa

New User


Joined: 02 May 2008
Posts: 77
Location: chennai

PostPosted: Thu Aug 25, 2016 5:20 pm
Reply with quote

hi,

I have a lengthy string defined as C(200). I need to insert that field into DB@ table using the SPUFI

The text looks like following

Text: PUT 'XXXX.ABC.FILE' into Xxxxx_file_location.txt

When i try to give the command it gives error giving -104 saying illegal symbol "."
1. How to i insert the string having combination of quotes and "." dots
2. How to use the contination if the strings is vely long.
Please advice
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1590
Location: Andromeda Galaxy

PostPosted: Thu Aug 25, 2016 6:13 pm
Reply with quote

Can you post the SQL which you have tried?
Back to top
View user's profile Send private message
vidyaa

New User


Joined: 02 May 2008
Posts: 77
Location: chennai

PostPosted: Thu Aug 25, 2016 6:16 pm
Reply with quote

Please find the details belOW

Code:


     INSERT INTO DB0VXXX.XXX
    VALUES
    (
      'ABC',
      'TERTRET',
      'C  ',
      'PUT 'ABC.FILE.NAME(0)'
claims_ut_xa.txt',
      CURRENT TIMESTAMP
     );
Back to top
View user's profile Send private message
Abid Hasan

New User


Joined: 25 Mar 2013
Posts: 88
Location: India

PostPosted: Thu Aug 25, 2016 6:22 pm
Reply with quote

Aside, can a moderator kindly mask the sensitive data; if the information in the text-shot is PROD/actual-customer data and someone from the TS's organization or otherwise spots it, can land the TS in deep trouble.


Edit: Kindly remove this post; it appears that TS has now edited their original post and removed the details.
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1590
Location: Andromeda Galaxy

PostPosted: Thu Aug 25, 2016 6:32 pm
Reply with quote

General rule you need to use two single quote if you need to a add one single quote
Back to top
View user's profile Send private message
vidyaa

New User


Joined: 02 May 2008
Posts: 77
Location: chennai

PostPosted: Fri Aug 26, 2016 4:08 pm
Reply with quote

how do we give the continuation
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Fri Aug 26, 2016 4:42 pm
Reply with quote

Quote:
how do we give the continuation


as per the manual.
Back to top
View user's profile Send private message
vidyaa

New User


Joined: 02 May 2008
Posts: 77
Location: chennai

PostPosted: Fri Aug 26, 2016 4:50 pm
Reply with quote

Thanks i got them..i did write the text till 72 column and then started the continuation from column 1 in second line and it worked out. Thanks for all your help icon_smile.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts How to replace a string dynamically i... CLIST & REXX 16
No new posts Control M features to check string in... Compuware & Other Tools 1
No new posts Can we Insert duplicates in Primary U... DB2 2
No new posts Need to split single line into two li... DFSORT/ICETOOL 7
No new posts insert into session tables with UR DB2 0
Search our Forums:

Back to Top