Job Category

asitagrawal · Post by **asitagrawal** » Tue Jul 03, 2007 6:06 am

Hi,

I am executing the below command from a before stage routine...

SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'TestTivoli';

the result contains Category............Testing\Tivoli\JobsNSeq1 records listed.

Now I want the remove Category............, for this I am using CHANGE function to remove it..

I there any other way ??

chulett · Post by **chulett** » Tue Jul 03, 2007 7:06 am

Please don't post the same question in multiple forums.

Your answer, of course, is yes. There are other ways to remove it after selection, but I'm sure there's a way to keep it from being generated in the first place. Problem is, I don't remember what in the heck how to do that.

One of the Ubers like Ray or Kim should be along eventually to help us out.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 03, 2007 7:20 am

Code: Select all

SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'TestTivoli' SUPPRESS COLUMN HEADING ;

chulett · Post by **chulett** » Tue Jul 03, 2007 7:31 am

Cool, thanks. I thought it might be one of those 'one word' style dealios ala 'DET.SUP'.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 03, 2007 7:37 am

You can also use COL.SUP but *technically* the full words are defined for SQL. COUNT.SUP might also be useful.

asitagrawal · Post by **asitagrawal** » Tue Jul 03, 2007 8:24 am

How to supress the number of records listed count ??

If possible, Please share where are these commands documented ??

Thanks

asitagrawal · Post by **asitagrawal** » Tue Jul 03, 2007 8:26 am

How to supress the number of records listed count ??

If possible, Please share where are these commands documented ??

Thanks

chulett · Post by **chulett** » Tue Jul 03, 2007 8:45 am

That would be the COUNT.SUP that Ray mentioned.

asitagrawal · Post by **asitagrawal** » Tue Jul 03, 2007 8:49 am

Am sorry,

I dont understand this please..

Please guide me for the usage of COUNT.SUP ?

What is the syntax ??

Thx..

asitagrawal · Post by **asitagrawal** » Tue Jul 03, 2007 8:50 am

Am sorry,

I dont understand this please..

Please guide me for the usage of COUNT.SUP ?

What is the syntax ??

Thx..

chulett · Post by **chulett** » Tue Jul 03, 2007 9:29 am

Just add it at the end of the query.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 03, 2007 9:51 am

COUNT.SUP (or COUNT SUPPRESS) suppresses display of the "1 records listed." message.

kduke · Post by **kduke** » Tue Jul 03, 2007 9:18 pm

These are Universe commands or options. They are documented in the Universe manuals. There are posts to where you can download these manuals. These commands are TCL commands and you can get some information with the TCL HELP command.

HELP COUNT.SUP

There are lots of options to suppress whatever you want. Ray teaches Universe classes as well as DataStage classes. I am sure he will sign you up if you want.