Does the NoSchema command remove the Disconnect command. That seems to be my
problem. I seem to always get a disconnect and no re-connect.
Patti
From: A. Razzak Memon <[email protected]>
To: [email protected]
Sent: Thursday, February 23, 2017 3:47 PM
Subject: Re: [RBASE-L] - Why can't we input a table anymore?
I simply could not resist ....
Did you know that you can also use the NOSCHEMA parameter of the
UNLOAD command to omit the character settings and CREATE SCHEMA
syntax from the beginning of the output?
Here's how ...
OUTPUT TransferHumptyTable_t.rmd
UNLOAD ALL FOR HumptyTable_t NOSCHEMA
OUTPUT SCREEN
Remember, you are ONLY limited by your knowledge and experience of R:BASE!
Very Best R:egards,
Razzak.
At 03:21 PM 2/23/2017, 'Patti Jakusz' via RBASE-L wrote:
>Hi Bruce, Are you saying I should get rid of the lines below?
>Patti
>
>SET SINGLE=NULL
>SET SINGLE='_'
>SET MANY=NULL
>SET MANY='%'
>SET IDQUOTES=NULL
>SET IDQUOTES='`'
>SET CURRENCY '$' PREF 2 B
>edit this out?--> DISCONNECT
>edit this out?--> SET STATICDB OFF
>edit this out?--> SET ROWLOCKS ON
>edit this out?--> SET FASTLOCK OFF
>edit this out?--> CREATE SCHEMA AUTHOR HEALTHY PUBLIC
>CREATE TABLE `newVR` +
>(`ssnum` TEXT (11), +
> `momdob` DATE, +
>
>
>
>From: Bruce Chitiea <[email protected]>
>To: [email protected]
>Sent: Thursday, February 23, 2017 3:13 PM
>Subject: Re: [RBASE-L] - Why can't we input a table anymore?
>
>Patti:
>
> From within your development database, have you tried:
>
>OUTPUT TransferHumptyTable_t.rmd
>UNLOAD ALL FOR HumptyTable_t
>OUTPUT Screen
>
>... editing out the few lines of schema creation commands,
>disconnecting from the development database, connecting to the
>production database, then performing:
>
>RUN TransferHumptyTable_t.rmd
>BROWSE * FROM HumptyTable_t
>
>... from the R> Prompt?
>
>Since this is a new table, your only concern would be duplicate
>column names/definitions.
>
>Bruce Chitiea
>SafeSectors, Inc.
>909.238.9012 Mobile
>
>
>------ Original Message ------
>Sent: 2/23/2017 11:36:46 AM
>Subject: [RBASE-L] - Why can't we input a table anymore?
>From: "'Patti Jakusz' via RBASE-L"
><<mailto:[email protected]>[email protected]>
>To: "Karentellef via RBASE-L"
><<mailto:[email protected]>[email protected]>;
>"RBASE-L Mailing List"
><<mailto:[email protected]>[email protected]>;
>"[email protected]"
><<mailto:[email protected]>[email protected]>
>Cc:
>
>Hello,
>
>I like to do all my coding work in a copy of our database. When I
>want to transfer any new tables to the live database, I used to
>Export the data & structure in the database copy and input it in the
>live database.
>
>For the last year or so, 9.5 wasn't letting me do that normally
>anymore. There was a disconnect comment in the exported table but
>no "connect Healthy.RB1" command. After a few trials I figured out
>where to stick the connect command.
>
>Now I have Rbase 10. I tried to stick the connect command where I
>thought it should go, just before the Create Schema command. But it
>still doesn't work. Some of the errors I see:
>
>R>input healthy_table_newVR_Data_STructure.tbl
>-ERROR- newVR is an undefined table. (2038)
>-ERROR- No database connected ( 325)
>-ERROR- No database connected ( 325)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>-ERROR- Unrecognized command - retype it ( 40)
>...
>
>
>Here is part of my exported table commands:
>...
>DISCONNECT
>SET STATICDB OFF
>SET ROWLOCKS ON
>SET FASTLOCK OFF
>CONNECT Healthy.RB1
>CREATE SCHEMA AUTHOR HEALTHY PUBLIC
>CREATE TABLE `newVR` +
>(`ssnum` TEXT (11), +
> `momdob` DATE, +...
>
>Can someone tell me what the problem is? And why has this gotten so
>difficult? Sometimes these files are huge and I don't think we
>should have to go in through an editor and stick our commands in the
>middle. Especially if it doesn't work and I have to keep hitting
>the tab key for 10,000 records.
>
>Thanks,
>Patti
>--
>You received this message because you are subscribed to the Google
>Groups "RBASE-L" group.
>To unsubscribe from this group and stop receiving emails from it,
>send an email to
><mailto:[email protected]>[email protected].
>For more options, visit
><https://groups.google.com/d/optout>https://groups.google.com/d/optout.
>--
>You received this message because you are subscribed to the Google
>Groups "RBASE-L" group.
>To unsubscribe from this group and stop receiving emails from it,
>send an email to
><mailto:[email protected]>[email protected].
>For more options, visit
><https://groups.google.com/d/optout>https://groups.google.com/d/optout.
>
>
>--
>You received this message because you are subscribed to the Google
>Groups "RBASE-L" group.
>To unsubscribe from this group and stop receiving emails from it,
>send an email to
><mailto:[email protected]>[email protected].
>For more options, visit
><https://groups.google.com/d/optout>https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
