I am having the below sql script from which we need to load the initial data as follows:
It is throwing an error as TPT_INFRA: At "select" missing SEMICOL_ in rule: Job Definition Body
Can you guide me in identifying the cause of these error
Thanks & Regards
This is not a FLOAD job. This is a TPT job.
The error message you are getting is a syntax error.
In order to help you, you need to provide the entire script.
You are either missing a semicolon somewhere, or you have parentheses or quotes that are no matching up.
It would also be helpful if you would tell us what version of TPT you are using.
Hi, I am using 15.0 teradata client
I am having doubts regarding FLOAD.
We run fload using Cmd eg; C:/FASTLOAD < fld filename; Is it right?
I am having a case stmt in the select list, Is case allowed under select stmts and joins between multiple tables.
Below is the script
FastLoad is for loading data into TD from an external source.
But your script doesn't load any data, you try to use a Select as source, of course this will not work.
Why don't you simply write a SQL Insert/Select?
Thanks much for your replies.
I created a script containing delete and insert statement which is working fine.
The above created script I run using tbuild -f file.txt -v Variable.txt.
Then I used the fastload utility and got the script generated, I updated that file with script changes and use file as input for tbuild which also worked fine.
I am having doubts when I run using tbuild -f A.txt (Is it calling FLOAD)?
when I run a txt file generated from FLOAD utility and running a tbuild -f A.txt(Is it fload)?
The script you showed is a FastLoad script, you can't run that with TPT/tbuild.
There's no FLOAD utility, just MLOAD.
Neither FastLoad nor MLoad generate scripts, only FastExport can create a matching MLoad script.