UVSH - HELP
Moderators: chulett, rschirm, roy
UVSH - HELP
Yes I need "HELP". actually, I need help to get help.
When I login to a uvsh session and type help it is garbage I tried to change my term type but I don't know what term type I should set it to.
This will be good if I can learn how to access the help, so as to work stuff out on my own.
Now the actual problem I have is I want to be able to do things like set linesize and set pagesize etc... as done in SQL*plus
When I login to a uvsh session and type help it is garbage I tried to change my term type but I don't know what term type I should set it to.
This will be good if I can learn how to access the help, so as to work stuff out on my own.
Now the actual problem I have is I want to be able to do things like set linesize and set pagesize etc... as done in SQL*plus
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There's no direct equivalent. First you need to know what terminal type your telnet client is emulating, for example VT100. The command to tell DataStage (dssh) about this is SET.TERM.TYPE
This command supports a number of options, which you can find out from HELP or from the UniVerse manuals. For example:
If you make use of these, ensure that the telnet client has the same settings.
Once the terminal type is correctly set, then the HELP command (which uses cursor positioning and screen formatting sequences) should work propertly. A quick check is the CS (clear screen) command.
If the dssh prompt is of the form $<50> then you (or someone) will need to recompile the terminal definitions (terminfo database) usingcommand.
Code: Select all
SET.TERM.TYPE VT100
Code: Select all
SET.TERM.TYPE VT100 WIDTH 132 LENGTH 27
Once the terminal type is correctly set, then the HELP command (which uses cursor positioning and screen formatting sequences) should work propertly. A quick check is the CS (clear screen) command.
If the dssh prompt is of the form $<50> then you (or someone) will need to recompile the terminal definitions (terminfo database) using
Code: Select all
uvtic
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Silly, perhaps, but you *did* notice the dots in "SET.TERM.TYPE", yes?
From the FAQ: "By default, PuTTY announces its terminal type to the server as xterm." Give that a shot. You should also be able to override that to whatever you like, I would think.
From the FAQ: "By default, PuTTY announces its terminal type to the server as xterm." Give that a shot. You should also be able to override that to whatever you like, I would think.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In the Connection branch in putty, what is the terminal type string being sent to the server? This becomes the value of the TERM environment variable in the operating system, from which dssh gets its initial terminal type. Mine is currently "xterm".
Your SET.TERM.TYPE needs to match this value. There is another command GET.TERM.TYPE (no arguments) to report the current setting.
That said, there does appear to be a problem with HELP alone. Try following HELP by a topic keyword, for example HELP HELP
Press Esc to get out of the scrambled Help screen. Press E to get out of a help topic screen.
Your SET.TERM.TYPE needs to match this value. There is another command GET.TERM.TYPE (no arguments) to report the current setting.
That said, there does appear to be a problem with HELP alone. Try following HELP by a topic keyword, for example HELP HELP
Press Esc to get out of the scrambled Help screen. Press E to get out of a help topic screen.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
I tryed "xterm" and "vt100" but both display illegible help text
Any other pointers?
in PuTTY if I look at $COLORS it is set to: /etc/DIR_COLORS.xterm:
I have no idea if that tells you anything.
Code: Select all
Using username "dsadm".
dsadm@mydomain.com's password:
Last login: Tue May 20 13:07:09 2008 from machine.name
$ cd /opt/IBM/Ascential/DataStage/Projects/MyDSproject
$ $DSHOME/bin/uvsh
DataStage Command Language 7.5
Copyright (c) 1997 - 2004 Ascential Software Corporation. All Rights Reserved
MyDSproject logged on: Tue May 20 13:10:43 2008
>GET.TERM.TYPE
xterm terminal emulator (X Window System) (xterm)
Width : 80
Depth : 24
in PuTTY if I look at $COLORS it is set to: /etc/DIR_COLORS.xterm:
I have no idea if that tells you anything.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Ok so in doing that it displays fine!ray.wurlod wrote: That said, there does appear to be a problem with HELP alone. Try following HELP by a topic keyword, for example HELP HELP
Code: Select all
+------------------------------------------------------------------------------+
| |
| HELP |
| |
| _________________________________________________________________ |
| |
| |
| Use HELP to display a description of a DataStage command or |
| keyword, a conversion code, a BASIC statement or function, a |
| DataStage SQL statement, or a BASIC SQL Client Interface |
| function. |
| |
| SYNTAX |
| |
| HELP [BASIC | CONV | PICK | SQL | BCI | helpfile] [item | *] |
| |
| HELP [item] FROM helpfile |
| |
| QUALIFIERS |
| |
| |
| More End Help List Commands |
+---------------------------+ Page Down +------------------------------+
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
And it's only in unqualified help - the List Command works properly in, for example, HELP SQL or HELP BCI.
If you want just a list of help topics you can execute a query.Note that this is UniVerse help - not all of the commands are used by DataStage.
If you want just a list of help topics you can execute a query.
Code: Select all
SELECT @ID HELP_TOPIC FMT '40L' FROM SYS.HELP ORDER BY 1;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
HELP SQL and HELP BCI work as you mentioned, as does the SQL to retrieve a list of commands (this will be of use to me). when picking on one command at random "SPOOL" and typing HELP SPOOL I again get encrypted babble.ray.wurlod wrote:And it's only in unqualified help - the List Command works properly in, for example, HELP SQL or HELP BCI.
If you want just a list of help topics you can execute a query.Note that this is UniVerse help - not all of the commands are used by DataStage.Code: Select all
SELECT @ID HELP_TOPIC FMT '40L' FROM SYS.HELP ORDER BY 1;
Do you know of a URL that has the entire uvsh HELP?
Now, just touching on the other issue (set linesize/pagesize) HELP BCI lists commands that by name, look like they might have something to do with this. Is this correct?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Nope. BCI emulates the ODBC API. The mechanisms for setting device width and length are SET.TERM.TYPE and TERM (the former is preferred). Setting column width is done in the query itself (like the FMT qualifier I used earlier.)
There is no URL with UniVerse HELP, however the UniVerse manuals are all downloadable from IBM website
There is no URL with UniVerse HELP, however the UniVerse manuals are all downloadable from IBM website
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.