DSXchange

4492_dsnoel wrote:try to use this

orchadmin rm C:\IS_Projects\DS_Data\Target\Sandbox\*.ds

What happens if there are multiple resource disks configured? Go with the shell script!

I experienced the same problem with Decimal(12,10) and finally was able to get the expected results by using a Char(12) column definition for the TeraData stage.

That was always my belief but I had an IBM rep inform me otherwise.

Thanks ArndW!

Would anyone (Ray ) know what role, if any, the column defined "key" plays in the creation of the dataset? Is there any reason that they should match the hash key for the partition?

Thanks!

Getting back to the original problem posted: getting the microseconds moved into the database table , we have found a simple solution: in a transform, change the datatype from Timestamp to Char(26) for the link to the db stage, even though the actual table is defined as Timestamp. This works, at lea...

Just be connected to any network that can serve you an address. Then it all works happily. I don't know the cause, but I have to use this technique way too often! ... To install the MS Loopback Adapter, do a search of Microsoft; there are explicit directions to configure the adapter from the contro...

This may be obvious but make sure you aren't resetting or recompiling the sequences. When the sequence is in abort/restartable status, you do not reset or recompile, just restart the sequence after fixing the failed job.

It's obvious they don't post for monetary compensation but now that DSX receives $50/year from each "charter" member, why not share the wealth with those who really earn it! I.M.H.O.

I would expect that a little $$ compensation would help keep the top posters posting; expecially now that is costs $$ to view their posts!

Hi Shesha For someone new to DS, like yourself, it isn't so easy to scan the posting and filter out what you need so I will try to explain the basics. The hash file is primarily used for lookups in transforms but also a great way of eliminating duplicate rows based on the key columns (destructive ov...

I would put a debug stop on the output link, run the job in debug mode and check the input data.

I created the routine using your code and got expected results everytime - but then, I had control over the input date strings!

-paul