DSXchange

'Track' how? Meaning, and do what with it?

So what if it isn't fine? What are the options for someone in this situation?

Sorry, how do you do what? It's on your client PC rather than the server but it's still a command line utility. If you're not sure of the syntax you can do an exact search for it here and find plenty of examples.

It's a client utility.

It's not... at this point you just need to wait for the right person to wander by and I imagine that would be Ernie.

This was unrelated to the original topic so split you out. If the property is optional then yes. From the documentation: Some properties are optional. These appear in the Available properties to add field. Click on an optional property to add it to the tree or choose to add it from the shortcut menu...

Varchar 1 & 3? How does that work? Seems to me your fields would need to be Varchar 5 to accomodate a full value - double digits for both plus the delimiter. And the target would need to be 8. :? An alternative to Ray's fancy FMT: '00:' : FMT(FIELD(InLink.TheValue,'.',1),'2"0"R')) : ':...

Let's start with what your processing job actually needs to do once it has all of this information, something I'm not clear on from your post. Let's say you generate your schema file and build an RCP job - what exactly does it need to do when it runs? That will determine how viable RCP itself is.

For an error like that, I would involve your official support provider. You may need a patch or have an ODBC driver issue but they should be able to help track it down.

splayer wrote:Tried it already.

Would have been prudent to note all that in the original post.

sam334 wrote:So, we believe, it will be always m.ss format.

It's good to believe... better to be certain.

Not all exist out of the box in the official lists... simply add it yourself as 'user defined' from what I recall.

He noted there would never be an hour component, so always minutes and seconds less than one hour is how I read that.

Are you looking for something... fancy? You could always use Field() to split the minutes and seconds then concat the results together. Left pad zeroes onto the short numbers.

Your TOT fields are always MM.SS or can they contain an hour value as well?