Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to insert a lengthy string having ',. into a DB2

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
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    Post subject: How to insert a lengthy string having ',. into a DB2
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

Moderator


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

PostPosted: Thu Aug 25, 2016 6:13 pm    Post subject:
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    Post subject:
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    Post subject:
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

Moderator


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

PostPosted: Thu Aug 25, 2016 6:32 pm    Post subject:
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    Post subject:
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: 2351
Location: Hampshire, UK

PostPosted: Fri Aug 26, 2016 4:42 pm    Post subject:
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    Post subject:
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    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 Insert System Runtime in HEADER In SY... Rick Ryan SYNCSORT 9 Tue May 26, 2020 9:01 pm
No new posts Get next 5 numeric from a string of '... maxsubrat COBOL Programming 7 Fri Apr 24, 2020 2:30 pm
No new posts Finding a string and concatinating mu... ArunkumarGanesan DFSORT/ICETOOL 11 Thu Jan 09, 2020 5:59 pm
No new posts DB2 Block insert (-803 Error Handling) NJDevils28 COBOL Programming 5 Mon Nov 11, 2019 7:54 pm
No new posts String to ASCII conversion JPLMARTINS COBOL Programming 4 Sun Sep 29, 2019 12:00 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us