Beta
×

Welcome to the Slashdot Beta site -- learn more here. Use the link in the footer or click here to return to the Classic version of Slashdot.

Thank you!

Before you choose to head back to the Classic look of the site, we'd appreciate it if you share your thoughts on the Beta; your feedback is what drives our ongoing development.

Beta is different and we value you taking the time to try it out. Please take a look at the changes we've made in Beta and  learn more about it. Thanks for reading, and for making the site better!

Exploring Teradata for Signs of Life

karniv0re (746499) writes | about 2 years ago

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

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.

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.

cancel ×

2 comments

Sorry! There are no comments related to the filter you selected.

Or... (1)

karniv0re (746499) | about 2 years ago | (#42110737)

You could just do Tools -> List Columns. I'm so smart sometimes.

Tags for slashdot (1)

Qzukk (229616) | about 2 years ago | (#42112857)

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

Check for New Comments
Slashdot Login

Need an Account?

Forgot your password?

Submission Text Formatting Tips

We support a small subset of HTML, namely these tags:

  • b
  • i
  • p
  • br
  • a
  • ol
  • ul
  • li
  • dl
  • dt
  • dd
  • em
  • strong
  • tt
  • blockquote
  • div
  • quote
  • ecode

"ecode" can be used for code snippets, for example:

<ecode>    while(1) { do_something(); } </ecode>