DSXchange

I don't know about Date fields, but I know you can substring and concatenate a Timestamp field for Oracle. I assume it is a string as Ray says, then the Oracle Enterprise stage converts it as needed.

John

What is the length of the Timestamp field? It should be 38. Try it.

John

You are very lucky - I have worked with DS for almost 7 years and have never had a mouse that will scroll Designer !
Very frustrating.

John

.dsx files are just text. You can compare them visually with a text editor or with a tool (download a trial of UltraCompare).

John

In Manager, highlight the job and go to Tools|Release Job. This job will be available to the Package Wizard.

John

I believe you are hitting the setting called EXACTNUMERIC. It is in the uvconfig file. The default is 15 and I would not recommend changing it. The comment in the uvconfig file says "Specifies the number of digits of precision before rounding occurs". Try using a value that is shorter than...

Look in the Director log of "JobExecucao_Bat_Vendas_2". The first log entry will list the parameters for the job - see if the "pFileName" parameter is set as you expect. You can add calls to DSLogInfo to your Job Control to write debugging statements to the log file. The format i...

Use a sequential file with this same table definition, define it is as a .CSV and add a constraint to write this record to it. Then look at the data in each numeric field to see which one is larger than the field.

John

So everything is fine until you get to Oracle? I found an Oracle article that refers to using NCHAR datatypes on specific fields of the table to support UTF-8. Here is the link:

http://www.oracle.com/technology/tech/g ... df/mwp.pdf

John

My memory of version 6 is that it counts licenses differently. If you open one client app., then use Tools - Run... to start another, it uses the same license. However, if you just run another client, it uses another license. I'm told now v7+ looks at IP addresses and only uses one license per conne...

Seems like a permissions problem to me - can you get to this folder with Windows Explorer when using the same login you use for DataStage?

John

Remember NUM will allow decimal point (.) and negative sign (-) as they are considered part of a normal datastage number.

John

You should look at the FAQ Forum. It tells you all about it. Here is the link: viewtopic.php?t=92038

John

Try the DS documentation in man_gde.pdf, a.k.a. Manager Guide.

John

What does the actual field look like in EBCDIC?
I would convert it to ASCII and write it to a sequential file then look at it. Was it converted correctly?

You might want to correct the View Data issue at some point, but right now you want to see if the data is being converted correctly.

John