I am trying execute a sql file from the script and the sql file has the following code snippet, which throws out the error given below
FOR C_FINELINE_LP AS CURSOR C_SLS FOR
SELECT * FROM WM_UTIL.FLT_DEP
WHERE LOAD_IND = 'N'
DO
.....
.....
....
END FOR;
FOR C_FLTSLS_STR_LP AS... (0 Replies)
hi,
I want to compile a program in C. It have a multiple calls to teradata. I have no idea how to compile in Aix.
The compiler that I should be use is cc.
I tried
cc -G -KPIC tdsfbd0358.c this generates a tdsfbd0358.i and after I have no Idea what I have to make, a link? how?... (3 Replies)
How do i connect from C program to teradata Database?
The C program is being executed from a Unix script, AIX.
I am calling a C program from a Unix shell script and the C Program executes some SQLs on Teradata Database. (3 Replies)
Hi, I've been trying to develop a script that performs the parsing of a log every 1 minute and then generating some statistics. I'm fairly new to programming and this is why I come to ask if I can lend a hand.
this is my log:
xxxx 16/04/2012 17:00:52 - xxxx714 - E234 - Time= 119 ms.... (8 Replies)
Hi All,
I am trying to export a file using Fast Export (Teradata) in UNIX. The desired output length is 550 bytes, but the output file is creating string till 75 characters. How to get the full length file?
.LOGON
.EXPORT file=export.txt;
SELECT CAST(('' ||
(CAST('UD ' AS CHAR(3))) || ... (2 Replies)
In a .txt file i have a set of teradata queries which i need to execute and capture result for all queries.Is there any way to run teradata queries from a file? (1 Reply)
Has anyone used either bteq or mload for inserting into a Teradata Database via perl. We're running Red Hat Enterprise 5.7. I've gotten the DBD::ODBC drivers installed and running. I installed the Teradata ICU, TeraGSS and ODBC pkgs. We are using perl to insert data across the network into... (1 Reply)
Hi, I am trying to use Teradata fastexport in ksh, but getting error as below
temp1.ksh: line 7: syntax error at line 10: `newline' unexpected
below is my code:
#!/bin/ksh
LOGON_STR="TDDB/user,paswd;"
DATAFILE=/path/a.lst;
DEBUG=0
>$DATAFILE
fexp > /dev/null... (3 Replies)
Hi All,
As we are using SQLPLUS command to connect Oracle Database in unix:
Like below syntax:
sqlplus username/password@dbname << EOI
SET HEADING OFF
SPOOL MAX_DATE_VAL.txt
select max(LAST_UPDT_DATE) from source_defect;
SPOOL OFF
here the result is stored in... (0 Replies)
Discussion started by: Shilpi Gupta
0 Replies
LEARN ABOUT DEBIAN
wml::std::box
wml::std::box(3) EN Tools wml::std::box(3)NAME
wml::std::box - Easily Create Rectangular Box
SYNOPSIS
#use wml::std::box
<box [attributes]>
...
</box>
DESCRIPTION
The "<box>" container tag puts its body into a nice rectangular box which itself is build via a HTML "<table>" construct.
ATTRIBUTES
"header"
This attribute switches between two totally different box variants. When it is present, a headlined box is created by the use of one
single table but with space GIFs. When this attribute is missing a standard box is created by the use of two nested tables but without
any space GIFs.
"bgcolor"
This sets the background color of the box.
"fgcolor"
This sets the foreground (text) color of the box.
"bdcolor"
This sets the color for the border of the box. The effect of this attribute is the automatic generation of a nested table construct to
achieve the optical effect.
"bdspace"
This sets the space between the border and the body of the box in pixels. Default is 4 pixel.
"bdwidth"
This sets the border width in pixels. Default is 1 pixel.
"width"
This sets the total table width in pixels. Default is no specific width for the standard box and 300 pixels for the headlined box
(because the headlined variant needs to know a fixed size to create the GIFs accordingly).
"summary"
Add a description of this table. This attribute is recommended in HTML 4.0.
EXAMPLE
<box bdcolor="#000000" bdwidth=1 bdspace=10
bgcolor="#ffffff" fgcolor="#000000">
Foo Bar Quux
</box>
<box header="Foo Bar Quux Header"
bdcolor="#000000" bdwidth=1 bdspace=10
bgcolor="#ffffff" fgcolor="#000000">
Foo Bar Quux
</box>
AUTHOR
Ralf S. Engelschall
rse@engelschall.com
www.engelschall.com
REQUIRES
Internal: P1, P2
SEE ALSO
HTML "<table>" tag.
EN Tools 2014-04-16 wml::std::box(3)