Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Gwen
Starting Member
1 Post |
 Posted - 2008-04-13 : 12:16:47
|
| I am trying to CREATE a member in a file on the AS400 using SQL. The member name is a variable and will change everytime the Insert command is issued. I have tried using the Alias command, but I am either doing something wrong, or it is not meant to be used to create a member that had not existed prior to the Alias statement. On the As400, the command to add a member is ADDPFM. Then an Override Data base file command (OVRDBF) is issued to point to the right member.Any help would be greatly appreciated!Thanks! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-13 : 15:56:20
|
| Don't think so. May try create sp on db/400 then call it from sql via linked server. |
 |
|
|
|
|
|
Can you CREATE a member on the AS400 from SQL?