DSXchange

Hi, thanks for reading and any help you can offer. Trying to set up a sequencer so that it restarts when an error or warning is encountered. Each activity in the sequencer has two triggers one for 'ok' and one for 'otherwise'. The 'otherwise' trigger sends processing to a e-mail activity then a term...

how can I keep the numbers to the right of the decimal?

StringToInteger giver me everything before the decimal position. I'm loading to a db2 field defined as integer...so string to decimal won't work. So not sure how to convert to integer and keep everything to the right of the decimal?

Thanks for reading. How can I convert an input field from varchar 255 to an integer. The fields are latitude and longitude. below is the value in the longitude field -84.469345 below is the value in the latitude field 39.074253 Both values come in as varchar 255, but need to convert to integer and k...

Ray, the job wasn't imported. Is teh warning telling me I need to add an NLS map name...was is an NLS mapname?

Hi, thanks for reading. Running a parallel job and noticed when it aborts it still inserts rows into the target table. Does DataStage not have roll back capability?

Job design

Dataset -> lookup -> transformer -> DB2 Connector

Hi, thanks for reading. Reading xml from a clob field in a db2 table. The job works, but we get this warning.

Bad NLS map name "" specified

Anyone know how to get rid of this warning or what the warning really means?

Hi, thanks for reading. We have a job that uses a shared container. A transformer sends data to the shared container only when the constraint is meet. However, even when zero records are sent from the transformer down the link to the shared container...the shared container still executes. Anyone kno...

That worked...thanks for your help rcanaran.

Hi, thanks for reading. Have a job that calls a shared container. The shared container performs a common lookup. The shared container is using RCP so on the input link we only define metadata for fields needed in the lookup...everything else passes through via rcp. Everything works, as far as the rc...

Thanks Ray...that works.

Thanks for reading.

If I have an input date and want to know the date one year prior using the input date as my starting point.

Trying to use DateFromDaysSince but need help with the syntax. Can someone please provide and example? Will it handle leap year?

Thanks.

In this case field1 can be many values, but it's easier for me to check for the values I don't want rather than checking for the values I do want. Is there a way to do a NOt IN() statement within a filter stage?

Hi, is it possible to pass different metadata definitions to the same generic job? RCP doesn't work for what we are trying to do. We want to use one job to load many tables. Want to pass everything the job needs by using job parameters.

Thanks everyone for your help.

I'm going to mark this resolved

We have two things that will work

awk -F"," '{for (i=1; i<=NF; i++) { print $i}}' (credit to DSguru2B)

or a script I will post once finished and tested.