Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need Impromptu macro to change table owner

Status
Not open for further replies.
ianhawksey

ianhawksey

MIS
Jul 11, 2002
27
0
0
CY
Hi Guys
I am trying to migrate an Impromptu 7 catalog from Informix to SQL Server. The table names are the same but the owner(s) is different. I understand it can be done with a macro. I have several owners which all need to end up as 'scheme'.

Can anybody provide me a macro to change the table owner from user 'informix' to user 'scheme'?

Thanks in advance
 
Status
Not open for further replies.

Similar threads

beegeeblueboy
  • Locked
  • Question
cdate function Impromptu 7.5 SQL script not recognised by SQL Server
Replies
0
Views
78
beegeeblueboy
beegeeblueboy
aortiz268
  • Locked
  • Question
Congos table of contents help pls
Replies
0
Views
54
aortiz268
aortiz268
deborahyr63
  • Locked
  • Question
how to code for service year milestones in 2020
Replies
0
Views
56
deborahyr63
deborahyr63
nickotine
  • Locked
  • Question
Format to display Years & Months
Replies
0
Views
59
nickotine
nickotine
NileshDhande
  • Locked
  • Question
Can I use web api as data source to cognos?
Replies
0
Views
76
NileshDhande
NileshDhande

Part and Inventory Search

Sponsor

Back
Top