DSXchange

what database are you using?

you can't truncate with a condition, that would be performing a delete.

If you partition your table by the column in question you could drop the partition which will probably be quicker that a delete if you have a huge table.

Stage variables are processed in order, you can therefore store values from the previous record in them svPreviousValue = svCurrentValue svCurrentValue = input.field svValueHasChanged = If svCurrentValue = svPreviousValue Then 0 Else 1 svCounter = If svValueHasChanged Then svCounter + 1 Else svCount...

Table_X_Oracle: Column Column_A floating point decimal is not fully supported; adjusting the scale. Table_X_Oracle: When checking operator: When binding output interface field "Column_A" to field "Column_A": Implicit conversion from source type "decimal[38,10]" to resu...

Sorry that was lazy of me, I only ready your last question and didn't see that everything I said had already been discounted. I have used both IsValid and SetNull in a column derivation before, but I guess something must be different. One thing to try is to use APT_DISABLE_COMBINATION = 'True' in th...

My source is XML file and I am doing lookup to pull the ID joining the creation date but I need to get the max(ID) and when I am trying to use this User-defined query from RDMS stage its not working.................. SELECT Max(schema.tblname.DocumentID),schema.tblname.Created FROM schema.tblname W...

double check the values you are passing into the parameters in your job from your sequence job. I imagine there is a mismatch there.

ds_developer, are you doing this in stage variables? you can't set a stage variable to null in DS EE. If you are using an unpatched version of DS client then it will let you compile it but won't work.

Are there only ever two records in table B ? Or are there a maximum number of these records? If so you can perform the join as you did, read out into a transformer, and using stage variable to hold the values flatten the structure out, writing the records into a hashed file with contact_id as the ke...

Hi, We have planned to move our platform from Server Edition to the Enterprise Edition and we are planning on the requirements needed for setting up the infrastructure for the PX 7.5 version on UNIX. We would like to hear some suggestions on what could be the needed parameter requirements for estab...

Craig, (or anyone else)

did you find a solution to this? or only a work around? having the same problem as you had, very annoying!

Is the job aborting? If so in the job properties uncheck the option "Automatically handle activities that fail" When a routine returns anything other than 0, DS thinks it is a return code other than 0 so it thinks the routine has aborted. When you are using routines to return values you ne...

i think the reason you are getting rejects is because although there are 99 characters in the field, the Euro signs are 2 bytes long and DataStage is counting the size of the field in bytes. I had a similar problem with fixed width files once, going through row merge stages it didn't work. Can't rem...

as you said run $DSHOME/bin/uvsh to get to the command line

LOGTO youProject

DS.TOOLS

choose option 5 - Administer Processes/Locks and follow the instructions.

have you set the correct LOCALE?

If you're not sure go into Administrator, select the project and go to NLS tab and somewhere in there you can set the LOCALE.

You can tell if NLS is insalled by looking at your stages in Designer. There will be NLS tabs in there, I think one for input and one for output, but maybe just on the properties bit, don't have it installed here and it's been a while. If it's not installed you will have to re-run the installation a...