View previous topic :: View next topic
|
Author |
Message |
vidyaa
New User
Joined: 02 May 2008 Posts: 77 Location: chennai
|
|
|
|
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 |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
Can you post the SQL which you have tried? |
|
Back to top |
|
|
vidyaa
New User
Joined: 02 May 2008 Posts: 77 Location: chennai
|
|
|
|
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 |
|
|
Abid Hasan
New User
Joined: 25 Mar 2013 Posts: 88 Location: India
|
|
|
|
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 |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006 Posts: 1592 Location: Andromeda Galaxy
|
|
|
|
General rule you need to use two single quote if you need to a add one single quote |
|
Back to top |
|
|
vidyaa
New User
Joined: 02 May 2008 Posts: 77 Location: chennai
|
|
|
|
how do we give the continuation |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Quote: |
how do we give the continuation |
as per the manual. |
|
Back to top |
|
|
vidyaa
New User
Joined: 02 May 2008 Posts: 77 Location: chennai
|
|
|
|
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 |
|
Back to top |
|
|
|