DSXchange

Thank-you,
it was indeed field 5

Hi, I am trying to get the "Full job description" (as seen in the properties dialogue of a job) from DS_JOBOBJECTS using dssh. Currently I can get the "short Job description" which I know is field 4, but I need to get the long description which I believe is field 7. I have been s...

Just one question before I do that.

Do I just add it in as I would for any "user defined" environment variable?

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. SELECT @ID HELP_TOPIC FMT '40L' FROM SYS.HELP ORDER BY 1; Note that this is UniVerse help - not all of the commands are used by ...

That said, there does appear to be a problem with HELP alone. Try following HELP by a topic keyword, for example HELP HELP Ok so in doing that it displays fine! +------------------------------------------------------------------------------+ | | | HELP | | | | ______________________________________...

Thanks for the suggestion Chulett,

I successfully did what you suggested, but still did not fix it.

when I asked for "GET.TERM.TYPE" in uvsh it did indeed pick up the change I made in PuTTY

I tryed "xterm" and "vt100" but both display illegible help text 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 Lan...

Thanks Ray, You would probably be just as good at mind reading as you would a grammar teacher. :lol: To be honest though, I don't care two hoots about that! After all this is a DataStage forum, not ProperEnglish forum :lol: Thanks Ray and Chulett for your help, it is very much appreciated. I will gi...

I see, so simply adding this environment variable through administrator and setting it to true will produce the intended outcome when including it as a parameter inside a job. Is this correct?

Thanks Ray,

I'm not sure if this makes a difference, but I am logging into vssh from the unix prompt in a putty session.

I tried SET TERM TYPE VT100 but this did not let me display help in a readable fashion.

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. No...

null values are empty strings, I think by setting the datatype to a timestamp it implies a fixed width. I came accross this somewhere: APT_IMPEXP_ALLOW_ZERO_LENGTH_FIXED_NULL Set this to true and it should allow a zero length ('') for the NULL value in the decimal fixed width field upon export. The ...

Note: You are about to post to a "Resolved" topic. Because of this, your post may receive limited attention. That's hilarious, my post actually received more attention :lol: There has never been a "ds" executable as a part of DataStage. That would explain why it doesn't work. Ca...

Very disappointing that an expensive GUI-driven application like DataStage doesn't provide a GUI to enter in the details of the database I want to connect to. I don't have permissions to update TNSNAMES.ORA on the server so I had to bug the sysadmin.

BTW FYI and for those that read this in future. This is not a problem at all, but I can only open uv via "uvsh" and "dssh"...

"uv" and "ds" do not work on my server.