![sql in xshell sql in xshell](https://img-blog.csdnimg.cn/20200131014822907.png)
I will need to take a more in depth look at your coding example to gain a better understanding of it. This may be a little more advanced than where I currently stand with powershell and ADO.NET. As for the redbook, have it! I'm still reading it though. Thank you for your input, I never thought to do this from powershell directly. Perhaps my attempts below will reveal a little more. I would agree that the server is partitioned (I think?) as I have been able to call different prompts like DB2/SQLJ/JAVA, just haven't been too successful with using them lol. Within this version, I have the option to utilize IBM DB2 Query Manager for i5/OS.
#Sql in xshell drivers
This knock off brought to you by attachmate (they added a couple bells and whistles and no longer offer support, ODBC drivers etc). This particular emulator is an adaption of IBM's 3270 emulator. IBM DB2 PE 9.7 FP5 SRM R1 is indeed DB2 LUW, or "COBRA".
![sql in xshell sql in xshell](https://imgs.developpaper.com/imgs/2020070610353965.jpg)
#Sql in xshell download
I know there are alternatives to what I am trying to do using PuTTY (not really an option at work), ODBC drivers (can't really download an IBM iSeries fixpack to get the drivers or repair the installation of iSeries as I can't anyways I don't have Windows admin privs)įirst, I want to thank you all for your comments and your insight. Ssh -1 not chdir to home directory /home/myusername: A file or directory in the path name does not existĪny insight as to what I am doing wrong or feedback on my questions is greatly appreciated. This is an example of just logging in over ssh as normal: PS H:> ssh -1 "mysql -u myusername -e 'show tables '"Ĭould not chdir to home directory /home/myusername: A file or directory in the path name does not existĬonnection closed to I have been able to do this but am unable to execute any SQL related commands so I am not sure what I am doing wrong.īelow is an example of me logging into the server over ssh via powershell and trying to execute something SQL related: This would require using SQL commands I am assuming?ĭo I need to log on as a root user in order to have read/write access privelages and perform anything SQL related?Īs mentioned above I have played around with ssh/qshell but I am having difficulty bringing up the mysql/sql prompt to do anything (I am using openSSH 4.7p1 / a unix CLI?) which I believe changes from $ to > when you successfully do this. lib/.file/.mbr file extensions that I cannot view using the 'cat' command. How do I find out more about the server via SSH commands? I can navigate the servers directories pretty easily and view files that I otherwise cannot see within iSeries. Is this only possible via port forwarding or tunneling? Wouldn't writing SQL scripts and executing them via SSH/Qshell be faster than using the iSeries emulator itself? Is qshell/SSH an efficient way to retrieve information from a database, or more specifically, the libraries that 'DB2 for iSeries' uses (.lib/.file extension files?)? I have started playing around with Powershell and SSH/Qshell, I have read a lot of documenation in IBMs extensive support section on their site regarding iSeries and all things related. It also has an FTP feature (which has its uses I guess). ISeries does have a feature where you can query information, interact with libraries (schemas if I have that right?) and tables using the i5/OS Query manager. VB macros are subject to smart pauses/timeouts as these are needed for scripts to work (like auto hot key)
![sql in xshell sql in xshell](https://www.netsarang.com/wp-content/uploads/2020/10/xshell-quick-commands-en-1.gif)
In order to pass/retrieve information to/from its database/server its users are limited to the speed of the program (among other things). Regardless of how you look at it, iSeries is slow IMO. However, you can only do so much with VB. I have written some from scratch in Visual Basic that are more flexible in the operations that they can perform. This feature of course has its limitations. Currently I am trying to learn more than the basic stuff I know about SQL (little rusty too).įor my previous and current job I work(ed) a lot with IBM's iSeries (or 'Mainframe' as some veterans like to call it.) Specifically it's version: IBM DB2 PE 9.7 FP5 SRM R1 on the DB2 i5/OS.Īs you may know, iSeries related emulators have a feature that allows its users to record macros for later playback. I have some experience with SQL, Visual basic and Auto Hot Key (awesome program). My apologies if this has been answered elsewhere. I have spent quite a bit of time scouring the overflow forums and using other resources to try and figure this out without success.