▪ outline format
▪ numerous pictures
▪ tired metaphors
▪ lack of detail on finer points (see below)
15.6.3. Creating Stored Procedure Query Subjects
Stored procedures that return scalar values cannot be used as a Cognos 8 query subject. And while you can pass parameter values into a stored procedure, return parameters from a stored procedure are not supported. You can, however, use this definition process to have a stored procedure act as a user-defined function that can be made accessible when creating a calculation, which will be mentioned briefly in the section "Turning a Stored Procedure Query Subject into a Function," later in the chapter.
So you _can't_ report back a sp scalar(single value return) as a query subject ~ but _can_ use in a formula.
1) Copy SQL text & open a browser window…
2) Go to the Wangz address and configure…
3) Click 'FormatSQL' and 'Copy to Clipboard' buttons
(for non-IE browsers -- highlight/righ-click~copy
text from lower textarea)…
4) Paste over existing SQL…
Google ~ SQLTidy…
Be sure to try the Server add-in…SQL
1) High-light text in Query window…
2) Open Query Designer…
3) Click anywhere in Designer…
4) Close Designer…automatically converts to ANSI'92
Google ~ SQLTidy…
Git looks like a pretty quick, predictable option. Neat features:
-single repository in your root
-can push~pull from other repositories
-content vs. file based ~ In my mind I think this may mean it is faster ~ smaller
Differences from SVN:
-Folders remain 'uncolorized' until you actual content(remember Git is
-Install Git and TortoiseGit
-Make a repository with Git GUI or ToroiseGit
Git provides 'Git Bash'(unix) and 'Git GUI' (simple point~click interface). However, my preference is TortoisGit. It hooks to Windows explorer and is pretty much _identical_ to TortoiseSVN.
Example of show-log ~ unified diff:
This video was really helpful in understanding how Git differs from other source control:
…and there is a preview of O'Reilly~Safari book:
Once again, my boat came in and I was at the airport.
ESI ~ Presentations by Michael T. Bee are licensed under a Creative Commons Attribution 3.0 Unported License.
Based on a work at http://michaeltbeeitprof.blogspot.com.
Permissions beyond the scope of this license may be available at mailto:firstname.lastname@example.org.