Well, that is true about a lot of the postings on this page, but so far we have not enforced rules as to how/what/where people can post their questions. Yes, it would be nice for people to only post questions that are related to the top title of this page. But sometimes, posts become conversations which morph into various topics.
i posted this question 2 days back but since its going to get lost in the other posts before getting answered i am posting it again. can you please answer my question.
in TPT there is an way to trim the Trailing Blanks using "TrimTrailingBlanks" option. Because of the way our source is giving us the data we get trailing blanks. Is there a way to do the same thing using TDLOAD?
Hi I am able to load the data to a table from flat below using below script. But values in flatfile are enclose with " so it is loading the same into table . Inorder to avoid loading " is there any attribute to be defined?
Our shop is pretty new to TPT and tdload. I am trying to test tdload but I'm having problems when I try to pass an Account ID.
I'm executing tdload using the following command: tdload --SourceFileName file.txt --TargetUserName user_1 --TargetUserPassword password_1 --TargetAccountId $L$DEV0 --TargetWorkingDatabase target_db --TargetTable target_tbl --TargetTdpId test_tdpid
I get the following error message: Teradata Parallel Transporter Version 13.10.00.04 TPT_INFRA: TPT04094: Error: Line 1 of tbuild Command Line: Invalid token expression: no tokens. Job script preprocessing failed. Job terminated with status 8. Teradata Load Utility Version 13.10.00.04 account_id: '$L$DEV0' + Res=0
This problem occurs when I specify the --TargetAccountId option. The process works when I try to remove "--TargetAccountId $L$DEV0" but I need to supply it as it is required in our shop. I'm pretty sure the Account ID ($L$DEV0) works because I am able to use it in BTEQ.
Does anybody know how I can resolve this? The 2nd problem I have with this is that tdload returns a 0 return code even though the process failed. Is this a bug?
got_boys_123: did you try enclosing $L$DEV0 in double-quotes? Also, on Unix, try to put a backslash ("\") in front of the "$" characters. The reason for the failure is that the Unix shell is processing the "$" before it gets to tdload.
tdload has a -S option to generate and persist the TPT script. This could be useful to save time in generating coorect TPT scripts. Where can the TPT script be located ? It was not in the working dirctorory. Thanks .