Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
1 reply
Subscribers
9 subscribers
Views
1218 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi all, I need to copy a table in MySQL through an Appian process. The
iainf
over 12 years ago
Hi all,
I need to copy a table in MySQL through an Appian process.
The function ExecuteQuery cannot run a statement like
CREATE TABLE pv!documentname LIKE tableName
because it doesn't return anything.
Query nodes cannot run statements like
CREATE TABLE ac!documentname LIKE tableName
becuase they cannot set names dynamically (using ACPs).
Can anyone advise a work around?
Thanks...
OriginalPostID-65152
OriginalPostID-65152
Discussion posts and replies are publicly visible
0
Brett Shomaker
Appian Employee
over 12 years ago
The out of the box smart services do not execute DDL statements. You'll have to create a custom smart service to do it:
forum.appian.com/.../Custom_Smart_Service_Plug-ins
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel