I need to create a control file with a pre-defined structure for a given table name. The table is in teradata.
Ex: Table Name: TBL1
I need to create a control file which will have tptstream script for this table. In this file I need to replace Varchar with the Char of same length and Integer with Char(11),Decimal with Char(length+2) etc.
User will provide the table name/names only. Please help me how to get the structure from the teradata and then create such file. I am in urgent requirement and any help will be highly appreciated.
Thanks in advance.
Last edited by Don Cragun; 06-10-2014 at 03:16 AM..
Reason: Add CODE tags.
UNIX gurus:
Following is what I am trying to do:
I need to create a control file for another file that I am creating. The information needed in the control file is the date in YYYYMMDD format and then the number of records in the other file right justified and lpadded with spaces of 20.
So... (5 Replies)
Hi,
I need to extract the table name from an oracle control file which comes as the last word in the third line.
Ex:
LOAD DATA
INFILE '/home/user/files/scott.dat'
INTO TABLE SCOTT.EMP_SAL
FIELDS TERMINATED BY..........
what i want to to is write the table name SCOTT.EMP_SAL to a... (2 Replies)
Hi,
I am using Cygwin.I created a new file and type into it using cat > newfile. When I open this using vi editor, it contains loads of extra control characters.
Whats happening? (1 Reply)
Hi,
I have four input files and would like to create an output file as a table. Please check the example below.
File 1.
111111
222222
333333
444444
File 2.
555555
666666
777777
888888
File 3.
aaaaa
bbbbb
ccccc
ddddd (2 Replies)
hi there, I am trying to create a stored procedure that i can pass the table name to and it will create a table with that name. but for some reason it creates with what i have defined as the variable name . In the case of the example below it creates a table called 'tname'
for example
... (6 Replies)
Hi,
I've several files with two collumns, where first collumn can be used as index.
filename1
and filename2
how to create a file
I should start with cat all files and extract first collumn to create an index? (4 Replies)
Hi ,
I have to create a file with 3 columns A,B,C. I have to read the column A,B values from a text pad. Where as Column a contains approximately 10 values and column B has 1 value which is constant. Column C is a version control column ,initially the value would be 1. (1 Reply)
I need to create the shell script load the few 100 table using the SQLLDR.
Need to generate the control file for each table using oracle table.
table has "table names" and "column names" using this need create the control file.
example table rows below
table_nme column_nme
DEPT ... (2 Replies)
Gents,
Can you please help me to create a pivot table from a csv file. ( I have zip the csv file)
Using the file attached, columns 1,28 and 21 i would like to get something like this output
JD Val 1 2 3 4 5 6 7 8 9 10 11 12 Total... (4 Replies)
Discussion started by: jiam912
4 Replies
LEARN ABOUT DEBIAN
alzabo::table
Alzabo::Table(3pm) User Contributed Perl Documentation Alzabo::Table(3pm)NAME
Alzabo::Table - Table objects
SYNOPSIS
use Alzabo::Table;
my $t = $schema->table('foo');
foreach $pk ($t->primary_keys)
{
print $pk->name;
}
DESCRIPTION
Objects in this class represent tables. They contain foreign key, index, and column objects.
METHODS
schema
Returns the "Alzabo::Schema" object to which this table belongs.
name
Returns the name of the table.
column ($name)
Returns the "Alzabo::Column" object that matches the name given.
An "Alzabo::Exception::Params" exception is throws if the table does not contain the column.
columns (@optional_list_of_column_names)
If no arguments are given, returns a list of all "Alzabo::Column" objects in the schema, or in a scalar context the number of such tables.
If one or more arguments are given, returns a list of table objects with those names, in the same order given.
An "Alzabo::Exception::Params" exception is throws if the table does not contain one or more of the specified columns.
has_column ($name)
Returns a voolean value indicating whether the column exists in the table.
primary_key
In array context, return an ordered list of column objects that make up the primary key for the table. In scalar context, it returns the
first element of that list.
primary_key_size
The number of columns in the table's primary key.
column_is_primary_key ("Alzabo::Column" object)
Returns a boolean value indicating whether the column given is part of the table's primary key.
This method is really only needed if you're not sure that the column belongs to the table. Otherwise just call the "Alzabo::Col-
umn->is_primary_key" method on the column object.
attributes
A table's attributes are strings describing the table (for example, valid attributes in MySQL are thing like "TYPE = INNODB".
Returns a list of strings.
has_attribute
This method can be used to test whether or not a table has a particular attribute. By default, the check is case-insensitive.
* attribute => $attribute
* case_sensitive => 0 or 1 (defaults to 0)
Returns a boolean value indicating whether the table has this particular attribute.
foreign_keys
Thie method takes two parameters:
* column => "Alzabo::Column" object
* table => "Alzabo::Table" object
It returns a list of "Alzabo::ForeignKey" objects from the given column to the given table, if they exist. In scalar context, it returns
the first item in the list. There is no guarantee as to what the first item will be.
An "Alzabo::Exception::Params" exception is throws if the table does not contain the specified column.
foreign_keys_by_table ("Alzabo::Table" object)
Returns a list of all the "Alzabo::ForeignKey" objects to the given table. In scalar context, it returns the first item in the list.
There is no guarantee as to what the first item will be.
foreign_keys_by_column ("Alzabo::Column" object)
Returns a list of all the "Alzabo::ForeignKey" objects that the given column is a part of, if any. In scalar context, it returns the first
item in the list. There is no guarantee as to what the first item will be.
An "Alzabo::Exception::Params" exception is throws if the table does not contain the specified column.
all_foreign_keys
Returns a list of all the "Alzabo::ForeignKey" objects for this table. In scalar context, it returns the first item in the list. There is
no guarantee as to what the first item will be.
index ($index_id)
This method expects an index id as returned by the "Alzabo::Index->id" method as its parameter.
The "Alzabo::Index" object matching this id, if it exists in the table.
An "Alzabo::Exception::Params" exception is throws if the table does not contain the specified index.
has_index ($index_id)
This method expects an index id as returned by the "Alzabo::Index->id" method as its parameter.
Returns a boolean indicating whether the table has an index with the same id.
indexes
Returns all the "Alzabo::Index" objects for the table.
comment
Returns the comment associated with the table object, if any.
AUTHOR
Dave Rolsky, <autarch@urth.org>
perl v5.8.8 2007-12-23 Alzabo::Table(3pm)