DSXchange

if char(10) then char(127): DSLink3.colB else 0 (using stage variable).

char(127) is - you are getting what you are putting in the column.
Is that what you meant to do?

Regards,

Hi,

Is this happening to the last column?
Are there any transformation being performed on the column involved?

Regards,

Palmeal wrote Raid 5 is not the best storage set up for writing - Raid 0 + 1 would be the best set up. Are your files spread around the disks or are the controllers trying to access the same disks at the same time. Again Raid 0 + 1 will randomise this and reduce disk contention. The rest of the pos...

Hi Lali_swam,

If you dont mind, could you please detail the steps that you followed in order to establish connectivity. Someone might benefit from following the steps you used.

Thanx,

You are able to generate reports using the command line. You could write a job that gets the job list, then looping thru that, run the create report command for each job. dsdesign.exe /H=hostname /U=username /P=password /O=omitflag project job_name | /SC shared_container_name /R /RP=report_pathname ...

You need to set up an ODBC connection on the Linux server. You will have to make changes to the .odbc.ini file with regards to specifying the DSN. This is in addition to making the changes to uvodbc.config. You need to modify the uvodbc.config file that is in the Project Directory as well as the one...

Check out this post

viewtopic.php?t=92425&start=0&postdays= ... vetoactive

Regards,

Check out this post:

viewtopic.php?t=89842&start=0&postdays= ... tatus+code

Regards,

Hi,

In order to try and find a solution to your error, more information is needed.

Like Eric said

Without a description of what you are doing and more information about the problem I don't expect you'll find the answer your looking for.

Regards,

Hi,

There has been posts covering this error. One of which is viewtopic.php?t=93118&start=0&postdays= ... tion+error

A search is bound to bring back more.

Regards,

This is from a post on DSXchange: rsrikant posted the following: Here is the fix for this issue. Proper rights should be given to the folder C:\Program Files\Ascential\DataStage so that the xml file used for compilation can be written. It means all the users who need to work on DataStage should have...

Just had to point out, If you look at the underlying routine, namely DateGenericToTimeStamp, it is not expecting date in the DS internal format, it is expecting iether a julian date, or one of several date formats, CCYYMMDD being one. I did the following in a routine, and it works fine: Deffun isDat...

On the Format Tab, there is a load button. This is what you would use to actually load the Format of the columns that are being defined. This would be "First Line is Column Names", your quote characters, delimeters etc.

Hope that explains it,

ArndW wrote:The 2Gb limit doesn't apply to the windows files (assuming NTFS), so if you created a large hash file this limitation ought not to apply to you. WHy are you being limited to files of 2Gb?

I was under the impression that this was the case on 32 bit OSs. Please clarify.

Did you by any chance apply the XP SP2? There are known issues regarding this. The following post mentions some of them: http://www.dsxchange.com/viewtopic.php?t=88883 There is a patch for XP SP2 on Ascential's EService Download page. Here's the text from the patch's readme... ______________________...