DSXchange

Try: Set the jobs corresponding column type to LONGVARCHAR to a length of zero along with the Array size property to a value of 1.

I agree with your design, I copied the job and replaced OC with a CopyStage. I did all my field validations in this job. The next job will just take the file and load it to the actual table. There is still a chance of truncating the table if any issue with loading data to table, but I have covered 9...

I would suggest you import the table metadata in DataStage and see how the column you are referring is defined. Based on that, if you see the length is not sufficient, you can define the column as LONGVARCHAR and don't give the length. In most of these cases, you can try different definitions and yo...

Hello, My requirement is to truncate and load an Oracle table every day with a new file. But the catch here is, do not truncate if there is any issue with the file. My design has a external file, XML Input, transformer and Oracle Connector. I have mentioned to truncate the table. But when the job fa...

Can you post the column definitions in DB2 and DataStage? Most of the SQL clients convert the data before presenting, where as DataStage will display the values based on the definition.

Hello, I know there are many posts related to this topic, but all of them are with older versions. My question is more around any better way to do this in latest versions. Issue. I have a huge XML file from a 3rd party application which has more than 30 repetition elements. I need to load all these ...

Try to implement this: > Aggregate using ACCT and DBR-CD. So, you will get max two rows for each account and all the corresponding amount summed > then combine both the rows into single - now if any accnt has both C and D, you will have both the columns in the same row > delete the duplicates - so t...

you can try my solution explained in the post -
viewtopic.php?t=152903

Remove invalid characters or replace string with another - when it has multiple occurrences... Input: DSLink3.Description Invalid String: &nbsp I want to replace it with Space: ' ' --Stage Variables: VariableName:svStartPos Initial Value: 0 SQLType: Integer Derivation: Index(DSLink3.DESCRIPTION,...

Can you please explain little more about your design.. You mentioned you are running the job in Keep mode and deleting the messages after you job read the messages. Are all the processes putting the messages in MQ are stopped when you are running your DataStage? If not, you might see more messages t...

This statement doesn't give any error, it is added by the datastage to give you the number of rows it updated. If you see the log, you will have a statement - Number of rows updated on the current node: x. the number of rows are coming from this variable. The original poster wanted the clarification...

replace your below condition:

If input.EFF_DATE='' OR IsNull(input.EFF_DATE) Then
input.EFF_DATE
Else
If STG > '1800' Then input.EFF_DATE else '1799-01-01'----------STG2

If I understand your requirement, you want to use some function similar to LIKE in Oracle. If substring of your oracle key is present in sequential file key, you want to output those records. In that case (you want only the matched rows), why don't you interchange your source and reference. have sou...

refer to the below post for Ray's solution using Mod function..
viewtopic.php?t=153014

Good to know...

No specific reason for using Index - I was testing this function as part of some other issue...you can use any other functions to split the field into two...