DSXchange

What is the oconv syntax you are using?
What format are you trying to convert it to?
What data type is the target field in your job?
What does your insert SQL look like?

From what I recall, we're using 9.2.06 actually.

Grants on tables are just 'normal' SQL you can run in the Administrator client as well as from the uv (actually ds) shell.

Why not just use the Administrator?

satya99 wrote:2. Set the Parameters as below:

Parameter name Prompt Type Default Value
BeginRec Enter Begin Row string 1
EndRec Enter End Row String 30000
BeginRec1 Enter Begin Row string 30001
EndRec1 Enter End Row String 60000

Umm... what?

ASCII transfer = convert record terminators, BINARY = leave alone and transfer unchanged.

Yes.

That's what you need to ask Support. I can't see anyone here knowing unless they've faced and resolved the same issue.

Is it possible to release and run a parallel job executable in Unix if it was initially compiled in Windows. Or should we export the job designs and recompile? Only if the compile did not involve a compiler. OSH scripts will directly transfer, I would think, but no true 'executables'. Recompile. Th...

Check your substring syntax in the online help or pdf documentation.

Check the status of your lookup and constrain your output to only those source records where the lookup succeeded. Link Variables are used for that:

There's nothing you can look for. Report this to your official Support provider.

there are 32 columns in the data file per record It is a fixed 26 columns file with '|' as separator Which one is correct? And if it has a field separator then it's not a 'fixed' file but rather a delimited one. There's no trick here. You simply have to manually verify the metadata you are using ma...

All that and you don't show us your actual DSExecute syntax.

I guess the only 'better' way would be to stop worrying about it and just leave them alone.