DSXchange

If the rows are in a table, you're going to have to group and merge into a single row using SQL. Or, if it's in a file, you're going to have to use an Aggregation step to merge the rows.

The missing piece was that DS Server arbitrarily enforces the data type in the metadata. Sequential file stage will apply decimal and scale metadata, so when changing the data to be character based you must remember to change the metadata.

When we post something here, it will live on for years. A new member can find one of our posts and try to do something like delete a job programmatically. There's some liability on our part if someone destroys an entire project by doing something they found here. If you notice, all of the internals ...

What language was that

How about, we're loathe to tell people how to tip-toe thru a minefield, becuase 9 out 10 times folks don't follow our directions exactly.

You need to multiply by 100, then pad with zeroes. Padding is simple.

FMT(link.column*100, "R%17")

Make sure your metadata for the column is VARCHAR, if it's still DECIMAL with a scale factor the job will strip off the zeroes again.

Why is the bottom most job hung? Is a query active? When DS submits a query to a DataBase, it doesn't look back to see if the Stop button has been pushed until the prepare finishes. Your best bet is to get the query killed in the database. Now, if the job has called a routine to go do something, unt...

Took awhile for your first post? "ps -ef|grep phantom" will show all job threads active. Look for the DSD.RUN threads, as they are the controllers. Failure to use the Stop facility in the DS Director means that if you use kill the job will not clean up its status and configuration files, plus any jo...

ODBC stage, toggle SQL choice to stored procedure.

It's either PC or server related. If you can't connect on your PC, can you connect on someone else's? If not, then the problem is server side. Are all projects out of bounds? How about a different server? Can you connect to dev but not prod? Are you using a "roaming" home? It seems like a permission...

This forum has thousands of posts regarding doing what you ask, just use the Search. Your DS BASIC manual is available under your Start button.

You'll never have a row go into an output link which requires a constraint check if there's no input rows. Your method doesn't work. Use an after-stage routine call and write a routine that checks the link values using the API libraries.

You're going to have to figure out the discrepancy in your SP. Maybe start by writing a simple SP that returns 1 columns and testing from there.

How do you know it's not happening? Is the script located on the DS server? Do you have some logging commands in the script to determine if it is executing, how far it's getting? How about posting the messages from the ExecDOS log entries.

First import the metadata definitions for the SP using DS Manager and then load into the stage.

Try out using the Folder stage to do the split out on the first column.