That is a very broad question. The best I can suggest are some pointers to pursue.tools that are more familiar to you. You will find things such as Bash, shell, vi, vim, and Python.
The native NonStop Guardian scripting language is called TACL. If you are completely new to NonStop, I think you would find the learning curve to be steep. There is a Posix personality within NonStop called OSS. In that environment, you might find
Your best option might be to do your extracts directly from Windows or Linux. If you can get the system owner to install the ODBC service, you can do your queries remotely and transfer the data extracts from there.
If you want to start browsing the HPE NonStop documentation, you can find it at: https://support.hpe.com/
Jon Marcus
On Friday, December 9, 2022 at 8:15:36 PM UTC-8, j-ma...@pacbell.net wrote:tools that are more familiar to you. You will find things such as Bash, shell, vi, vim, and Python.
That is a very broad question. The best I can suggest are some pointers to pursue.
The native NonStop Guardian scripting language is called TACL. If you are completely new to NonStop, I think you would find the learning curve to be steep. There is a Posix personality within NonStop called OSS. In that environment, you might find
manager needs to do some general configuration before SFTP is usable by non-privileged users, and I believe there is some central key/password component of SSH2 in which passwords must be set up. I don't know the details of that password setup, so you'dYour best option might be to do your extracts directly from Windows or Linux. If you can get the system owner to install the ODBC service, you can do your queries remotely and transfer the data extracts from there.
If you want to start browsing the HPE NonStop documentation, you can find it at: https://support.hpe.com/
Jon MarcusI did not notice this question back when it was first posted or I would have replied sooner.
What Jon suggests is not bad, but might be more complex than what is needed. He is right in observing that the question was not very specific.
If we make the assumption that you do not need to pass parameters that vary each time you run the script to either the SQL or SFTP part, you can do things very easily, something like this:
Put the SQL/MP commands you want to run in an Edit file named SQLCMDS.
Put the SFTP commands you want to run in an Edit file named FTPCMDS
Create an Edit file, call it RUNIT for this example, that looks like this:
SQLCI/IN SQLCMDS/
SFTP -b FTPCMDS user@ip-address
Then, at a TACL prompt, you would run the commands via the command:
OBEY RUNIT
I have not used SFTP on the NonStop system, but I know it is there (part of the SSH2 product). The commands SFTP accepts are documented in the NonStop SSH manual. They are mostly the familiar FTP commands, plus some additions. I believe the system
If parts of the SQL command or SFTP commands need to be specified for each separate time you run the script, there is a fairly easy way to do that, which does not require learning very much TACL. I won't complicate this answer to try to describe that,but if you do need to be able to specify parameters at the time you run the script, describe in a little detail what you need to specify, and we probably can show you a simple way to do that with TACL that won't require that you learn very much about
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 307 |
Nodes: | 16 (2 / 14) |
Uptime: | 108:17:09 |
Calls: | 6,852 |
Calls today: | 3 |
Files: | 12,355 |
Messages: | 5,416,059 |