Follow Slashdot stories on Twitter


Forgot your password?

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

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.


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.

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'

(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:

"How many teamsters does it take to screw in a light bulb?" "FIFTEEN!! YOU GOT A PROBLEM WITH THAT?"