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
 

 

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: 70
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: 1529
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: 70
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: 65
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: 1529
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: 70
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: 1715
Location: 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: 70
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
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am
No new posts Insert Lines in JCL with Rexx after a... Willy Jensen CLIST & REXX 3 Tue Aug 30, 2016 4:18 pm
No new posts Random Password (in string format) ge... ezhavendhan COBOL Programming 10 Mon Aug 29, 2016 3:18 pm
No new posts Which function does the Ampersand (&a... Andi1982 PL/I & Assembler 3 Wed Aug 24, 2016 2:05 pm
No new posts Need a help how to replace a string i... gurunath82 CLIST & REXX 12 Tue Jul 26, 2016 11:43 pm


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