Forgot your password?
typodupeerror
Medicine

karniv0re's Journal: Exploring Teradata for Signs of Life 2

Journal by karniv0re

First of all, as I mentioned in my previous post, I wanted to talk about archiving my Slashdot journal to my Google Docs (Drive, whatever) account.

Done.

I moved all one 128 posts by hand to a Google Drive folder. Lots of copy/pasting. Now all my text is searchable within my Drive account, which I think is awesome. I still like being able to troll through old entries on Slashdot, but if /. should ever abandon me (God forbid), at least I have liberated my data.

Second of all, I am just now noticing comments some of you have left on this journal, some many years ago. My apologies for never writing back, I honestly didn't think anyone read this but me, which is why I write it the way I do. It's for me to look back on, reminisce, be embarrassed by, and remember how I did things (man, I can't tell you how many times I've looked back to Security Initiative 2008 to remember how to work with encrypted drives). But I do write it with the intention of making it open for errrrybody.

On a total tangent, I've been battling with this health issue where I can't seem to get a deep breath very easily. Usually requires yawning to satisfy my "air hunger" and I noticed that sitting up straight helps, but man it's getting annoying. Googling the issue reveals no real cause (anxiety [I have none], artificial sweeteners [been drinking them most of my life, never had problems before], asthma [don't have it], etc) or reason for concern, but it's annoying. And so I suffer. Whatever.

Ok, on to Teradata. I'm trying to aggregate some data from some Teradata tables for our finance group. with little to no information and not much assistance on the matter. I was given a sample SQL statement and a list of demands (requirements). So far, I've requested access to the tables with our application ID and I've been able to execute the sample query with some simple modifications, (they were executing it as an openquery call through SQL Server - ugh).

But not all the data in the demands (requirements) was in the query, so I need a way of seeing the structure of the tables. Teradata SQL Assistant is helping with this a bit. It's not as sweet as DBViz or PL SQL Developer, but it's better than running or which isn't even working - keeps timing out. But in SQL Assistant, there are views. I right clicked on "TablesV" and hit browse and it populated a query statement for me. I added in a WHERE clause and got all the column names.

[code]
Select DataBaseName, TableName, Version, TableKind, ProtectionType, JournalFlag, CreatorName, RequestText, CommentString, ParentCount, ChildCount, NamedTblCheckCount, UnnamedTblCheckExist, PrimaryKeyIndexId, RepStatus, CreateTimeStamp, LastAlterName, LastAlterTimeStamp, RequestTxtOverflow, AccessCount, LastAccessTimeStamp, UtilVersion, QueueFlag, CommitOpt, TransLog, CheckOpt
From DBC.TablesV
WHERE DataBaseName = 'myDBName'
AND TableName = 'myTableName'
[/code]

(By the way, does anyone know how to format code in these journals? They seem to have removed the "code" tags, and "pre" doesn't work either.)

(More tangents: I guess my breathing issue is on Wikipedia: Dyspnea, again none of those things sound like anything I have. Weird.)

(Can you tell I have A.D.D.?)

After getting all the column names, it becomes a little easier to figure out what goes to where and what I need to query.

This discussion has been archived. No new comments can be posted.

Exploring Teradata for Signs of Life

Comments Filter:
  • You could just do Tools -> List Columns. I'm so smart sometimes.
  • I don't know what posting mode you're using, but you can use <tt> for inline monospace font and <ecode> for

    blockquoted monospace code
        which might even indent like python

"No problem is so formidable that you can't walk away from it." -- C. Schulz

Working...