Run script to insert multiple records into progress DB

Yahoo Archive
1

Nothing wrong with an updateable dashboard in the Application, but my reading of this wasn’t about an updateable dashboard, it was about adding data completely outside the application and directly in SQL or Progress.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Anthony Gercar
Sent: Tuesday, March 18, 2014 1:26 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Run script to insert multiple records into progress DB

 




What's wrong with updateable dashboards?

Sent from my iPad


On Mar 18, 2014, at 12:56 PM, "Ned" <TechnoBabbly@...> wrote:

 

Just add onto this,

 

You will also void your warranty and Epicor Support if you do this on a SQL DB as well.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, March 18, 2014 9:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Run script to insert multiple records into progress DB

 





You don't want to do it like that.  Not because this db is Progress, but because there are a bazillion other factors to consider when doing an import on a relational db.  Technically, yes,  you can do it like you can in SQL.  But you will void your warranty and Epicor Support will gladly not assist you until you provide them with your Corporate credit card number. 

 

Check this out.. it does precisely what you want and it's safe and supported:  http://bit.ly/PLIRtA

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of enottage211@...
Sent: Tuesday, March 18, 2014 9:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Run script to insert multiple records into progress DB

 

 

I can not seem to find any information about scripting for progress databases.  I just need to add multiple records and would not like to enter them in one by one.  There has to be a way to run multiple insert statements like SQL.  Any help would be appreciated.  

 

 








2
I can not seem to find any information about scripting for progress databases.  I just need to add multiple records and would not like to enter them in one by one.  There has to be a way to run multiple insert statements like SQL.  Any help would be appreciated.  

3
Oh boy... I think we need to have an automated response for these in pace.


Can it be done? Yes
But you should never, ever in a billion years do this. It violates your service agreement and guarantee , epicor will frown and even cry a little when (not if) you blow up your DB. The Business Logic is there for a reason please use DMT to load several records at a time. I understand its tempting but its not worth the risk.


Thank you



Jose C Gomez
Software Engineer



T: 904.469.1524 mobile


Quis custodiet ipsos custodes?


On Tue, Mar 18, 2014 at 9:30 AM, <enottage211@...> wrote:

  
<div>
  
  
  <p>I can not seem to find any information about scripting for progress databases. &nbsp;I just need to add multiple records and would not like to enter them in one by one. &nbsp;There has to be a way to run multiple insert statements like SQL. &nbsp;Any help would be appreciated. &nbsp;</p>


</div>
 


<div style="color:#fff;min-height:0;"></div>

4
DMT tool?


From: "enottage211@..." <enottage211@...>
To: vantage@yahoogroups.com
Sent: Tuesday, March 18, 2014 9:30 AM
Subject: [Vantage] Run script to insert multiple records into progress DB



I can not seem to find any information about scripting for progress databases.  I just need to add multiple records and would not like to enter them in one by one.  There has to be a way to run multiple insert statements like SQL.  Any help would be appreciated.  






5

You don't want to do it like that. Not because this db is Progress, but because there are a bazillion other factors to consider when doing an import on a relational db. Technically, yes, you can do it like you can in SQL. But you will void your warranty and Epicor Support will gladly not assist you until you provide them with your Corporate credit card number.Â

 

Check this out.. it does precisely what you want and it's safe and supported:Â http://bit.ly/PLIRtA

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of enottage211@...
Sent: Tuesday, March 18, 2014 9:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Run script to insert multiple records into progress DB

 

 

I can not seem to find any information about scripting for progress databases.  I just need to add multiple records and would not like to enter them in one by one.  There has to be a way to run multiple insert statements like SQL.  Any help would be appreciated.  

 

6

Just add onto this,

 

You will also void your warranty and Epicor Support if you do this on a SQL DB as well.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, March 18, 2014 9:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Run script to insert multiple records into progress DB

 




You don't want to do it like that.  Not because this db is Progress, but because there are a bazillion other factors to consider when doing an import on a relational db.  Technically, yes,  you can do it like you can in SQL.  But you will void your warranty and Epicor Support will gladly not assist you until you provide them with your Corporate credit card number. 

 

Check this out.. it does precisely what you want and it's safe and supported:  http://bit.ly/PLIRtA

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of enottage211@...
Sent: Tuesday, March 18, 2014 9:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Run script to insert multiple records into progress DB

 

 

I can not seem to find any information about scripting for progress databases.  I just need to add multiple records and would not like to enter them in one by one.  There has to be a way to run multiple insert statements like SQL.  Any help would be appreciated.  

 

 




7
What's wrong with updateable dashboards?

Sent from my iPad

On Mar 18, 2014, at 12:56 PM, "Ned" <TechnoBabbly@...> wrote:

 

Just add onto this,

 

You will also void your warranty and Epicor Support if you do this on a SQL DB as well.

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Vic Drecchio
Sent: Tuesday, March 18, 2014 9:45 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Run script to insert multiple records into progress DB

 




You don't want to do it like that.  Not because this db is Progress, but because there are a bazillion other factors to consider when doing an import on a relational db.  Technically, yes,  you can do it like you can in SQL.  But you will void your warranty and Epicor Support will gladly not assist you until you provide them with your Corporate credit card number. 

 

Check this out.. it does precisely what you want and it's safe and supported:  http://bit.ly/PLIRtA

 

 

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of enottage211@...
Sent: Tuesday, March 18, 2014 9:30 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Run script to insert multiple records into progress DB

 

 

I can not seem to find any information about scripting for progress databases.  I just need to add multiple records and would not like to enter them in one by one.  There has to be a way to run multiple insert statements like SQL.  Any help would be appreciated.