DSXchange

Is a molecule a small mole?
(Sorry Mike, couldn't resist.)

Or you can use Oconv(number, "MD0") (masked decimal with no decimal places) or you can use Fmt(number, "16R0") (16 characters wide, right justified, with no decimal places), either of which allow you to round (the default) or truncate ("MD0T" or "16R0T" respectively).

"Why does Num('1E2') returns True? "

6.023E23 is "scientific" (or "exponential") notation. It means 6.023 multiplied by 10 raised to the power 23. If you remember high school chemistry you will recognise this as Avogadro's number.

"As a bonus, it also creates the VOC entry." This is the F pointer to which you refer. Yes, you drop it using DROP TABLE hashedfilename; if it was created with CREATE TABLE. I prefer not to use mkdbfile because it does not populate a file dictionary, and I DO like to have my metadata recorded.

Can you be precise about which utility you are using to run the job? Is it dsjob (command line interface), or the SDK routine UtilityRunJob?

Search the forum for the SETFILE command.

You need to create a pointer (which is stored in the VOC file) to tell DataStage SQL queries where the hashed file is.

DSJ.STAGELASTERR is a constant, whose value is 2. It is meant to be used as the second argument of the DSGetStageInfo function when you want to determine whether there was any error in executing the stage. LastError = DSGetStageInfo(hJob, StageName, DSJ.STAGELASTERR) hJob is a job handle obt...

Not the only way! The CREATE TABLE statement supports DATA and DICT clauses that can be used to specify location of the data and file dictionary portions. CREATE TABLE hashed_file_name DATA /dirpath/hashed_file_name DICT /dirpath/D_hashed_file_name ( column definitions... ); As a bonus, this...

Do you have an export or a backup from the previous night? A partial import from the export is the easiest to do. Restoring from system backups is truly painful. You need to preserve (export) any work you've saved since the backup, delete the project, reinstate the project directory from backup, the...

The ";1" in the error messages suggests that you're on HP-UX. Can you do a find command and track down where D.SL, DSR3.SL and DSR3.Senu actually are? If that location is not any of the directories in SHLIB_PATH it will need to be added to SHLIB_PATH.

Not sure about "where" it's gone, but I can confirm that it no longer exists at 7.1r1. The functionality remains, however, via the DS.TOOLS menu on the server. Option 4 (check integrity of job files) will - among other things - track down any orphans and delete them (checking with you first that it ...

Hi All, When i tried to run the job's from the command prompt, I am getting an error like this "Verb "DSJOBS" is not in your VOC". Please suggest some way to rectify this issue. Thanks & Regards, Akhil Please show us the command that used "DSJOBS" (which isn't a command in the DataStage environment...

C:\Program Files\Ascential\DataStage\DSExport-DSX.xsl and C:\Program Files\Ascential\DataStage\DSExport-HTML.xsl are the two default style sheets, while C:\Program Files\Ascential\DataStage\DSExportSchema.xsd is the schema definition.

It's complaining about your data, not about your metadata.
Check your data (perhaps using ProfileStage or AuditStage) to determine whether there are any values that do not fit the metadata definition, for example out of range, non-numeric, and so on.

Welcome aboard! :D I'm not aware of any method of implementing -cc through DSSendMail unmodified. You can customise the template (not sure how to add CC here and pass the CC addresses, though). What I normally do is send to a list, which redistributes to the appropriate users. I've been able to get ...