DSXchange

"Dropping an index" is a Database term; it is explained in great and painful detail in the appropriate forums. Basically when you write to a table, you not only write the data but simultaneously the Database does such things as check column or table constraints, fire off triggers and maintain the in...

Vinay,

go to the columns list in the source or target stage, right-click on a column and "edit row" will bring you into the attribute editor. Then you can use the on-line help or the manual to get any additional information answered, but you can see the null-handling attributes on the screen there.

snassimr,

as Sainath and others have stated, the source of this routine would be nice as it seems to be the only place, from what you've described, where something might be working differently between your two different types of run.

You can always specify your null handling in the column declarations, for instance making each column change nulls into some other value such as "0". This way you wouldn't need to do it explicitly during the processing of each column.

Heather, in DataStage Basic you can use ", ', or / as a quote character interchangeably. So you can assign a double-quote via '"' or /"/ .

So what does this SDTToDateNumeric routine do? Plus you don't want to use the ( ) around your function, either.

the output of "DEL /?" Gives us: C:\Documents and Settings\guest3>del /? Deletes one or more files. DEL [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names ERASE [/P] [/F] [/S] [/Q] [/A[[:]attributes]] names names Specifies a list of one or more files or directories. Wildcards may be used to delete multip...

I think I would make link 2 write to a sequential file, and then continue from the sequential file to the rest of the processing. The rest won't continue until all the data has been processed and the data source exhausted. Doubles your I/O but solves your issue (although I am curious as to why you a...

Kumar,

I think that what you did was get rid of a warning message but are you sure you aren't generating junk data? How are you converting a decimal number into a valid Date, i.e. how does DS know what kind of a rule to apply?

You need local admin rights to install any DataStrange clients

I recall having similar issues with InstallShield packages. Check your Control Panel "add or remove programs" to see if the system still thinks that some software is installed and remove it, reboot and then re-try the install. I think that the InstallShield application plays around in the registry p...

Sonia,

There is a "multi-client manager" on the installation CD which does just that.

Venkat, I cannot think of a way to let the routine know from which column it was called, the DSGet...() routines go down to a link/stage level only. I think your only way of getting this information is to put a 3rd parameter with the name of the column into the call. You could always code it with ju...

I know of the unix level "uv -version" or the TCL command "LIST VOC WITH @ID EQ 'RELLEVEL' F2" but that is more the underlying Engine version. I thought there was a smat command to get this but couldn't find it.

Srekant, think about what Ray and the DS job are telling you: the file has 1146600 bytes and a fixed width of 716. This is not correct; since the filesize is not a multiple of 716. Because this is wrong, DS cannot partition the reading of this file across processes. Look at the same file format whic...