DSXchange

If you right-mouse click on the column and "edit row" you will come to a screen where you can specify more details on the column. Make sure that the USAGE is indeed COMP and that your sign indicator is unsigned.

If you want to share a sequence for use in multiple projects, you will need to copy the function and replace the OPEN statement as well as the file creation one with OPENSEQ and shell call to mkdbfile so that the KeyMgtGetNextValueConcurrent uses the same physical file no matter which project is cal...

You can do it as part of a modify stage as well, or it might be possible to remove whitespace from the fields in the field definitions of a sequential source file (I'm not certain); but you are using a fixed-width file and in that case you cannot do so in the stage definitions.

Michael,

the StringtoTimeStamp does not expect that format, it defaults to that format. You need to specify that you need a different format, using StringToTimeStamp(In.Col,"%dd-%mmm-%yyyy %hh:%nn:%ss")

The routine stores it's history information into a local file, so your generated numbers in any different project will be different; i.e. they will continue from where they left off last time.

The CREATE.FILE and RAID commands are TCL ones, and you don't need or use them with DataStage BASIC coding. The programs you will work with in the Manager - the "Routines" type, get stored in a special repository file; thus the normal RAID utility will not work (without a bit of tweaking). You can c...

I guess we have different ideas of clarity, then.
What happens when you manually start the teradata mload from outside of DataStage?

Yes, you can do that. But that isn't what Colin is asking. He is looking for the instance information.

Michael - could you explain "no luck"? This is the correct function to perform the conversion.

How many nodes in your config file? Try to run with a 2-node or a 1-node and see if your error persists. Also, are you reading a partitioned table and have you specified any explicit repartitioning in your job?

F1 needs to be "JOB" and the invocation ID is part of the record ID.

Kumar - I skipped the administrator client because it is not bound to a single project, but only to a single instance of DataStage server.

Try creating a dummy file with 3 rows of data, row 1 with 500 "a"'s, row 2 with 500 "b"'s and row 3 with 500 "c"s and see what your output is. You problem is most certainly settings in the FTP stage, but I don't know what you have done. Is your data field CHAR(500) with display of 500 as well?

It would be in the RT_STATUS file, where the key contains the instance name and the start date is in column 3.

Ok, what are your load options set to? Are you trying to do a delete table in there and do you have sufficient SQL permissions for all actions you intend?