DSXchange

Is there any restrictions on FTP? or its just that you dont want to add an extra step.

If there are no restrictions on FTP then you can use the FTP plugin stage to read the remote file

Add Five stage variables samplVar1(definition)- If LINK.SAMPLEID = samplVAR2 then 1 else 0 samplVar2(definition)- LINK.SAMPLEID testVar1(definition)- If LINK.TEST = testVar2 then 1 else 0 testVar2(definition) - LINK.TEST sequence (definition) - If samplVar1 = 0 or samplVar2 = 0 then 0 else sequence+1

Open it Microsoft Excel.

what does your SQL is trying to do? datastage jobs are made to ease out the SQLs into seperate data flow. if you look at it crudely, everything that can be done in datastage can be done in a SQL, hence we dont need datastage. but the crux is that datastage does it better, faster, easier and with opt...

when you made a cron entry did you compile the cron jobs? run the following command: crontab <cron file name> you can check by the command crontab -l and you will get the list of all scheduled jobs. its a basic but if you dont fire the crontab command after editing cron, then your entry will be in c...

600 lines of SQL.
wonder why they cant be implmented using a job

and your job design?

if you are using to extract and load into tables in the same job with so much data, i have observed it to be slower in server jobs than in parallel ones.

have you modified td.env file and made an entry there?

chulett wrote:

I know! I'll just write a bot that crawls the site and posts 'Time to mark your post as Resolved!' messages to any open issue I can find. I'll be caught up in no time.

another suggestion for you. Everytime ray posts a reply, just reply with the words "thanx a lot"

Omg. he is going from strength to strength.

does he uses jet engine for dinner?

thanx a lot ray

I tried searching the forum and goolge but found nothing on this topic. I have one of my DB2 load jobs failing due to the reason given below: SQLSTATE=S1000, DBMS.CODE=-668 [DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver][UDB DB2 for Windows, UNIX, and Linux]CANNOT ADD COLUMN...

a2love wrote:The string manipulation worked well, however is there a better command than len(in.col) as it returns the max length of the string, not its current trimmed length (just wondering).

len(Trim(in.col," ","A"))

I am trying to be funny:-P

depends on how your table was created.

no credits to oracle for that.

Please give a sample of what you are getting in the data. your post is too vague for us to comment on it.
even alexander guessed what you must be facing.

Do not get deep into the work tables created by teradata. they will be created as per your input file schema. so if you are defaulting some values in your datastage job then the work tables will be created according to that automatically. What i would suggest is instead of teradata stage as output s...