DSXchange

Thanks for feedback. We are wanting to load these values by dynamically creating the schema file. Basically, we want them to be date values in the database. I don't know of method to convert them unless I was to read the file as a fixed layout, and then convert them to dates for the load. Which mean...

Is there any help on Formating of Date and Timestamps for Schema Files. I need them to load into Teradata with the correct format. Here would be an example of a schema file. The input file is pipe delimited, however when DUE_DATE is null on input file, we get ||, so the format of 10 bytes below fail...

Thanks for the help. Going from VARCHAR to NVARCHAR eliminated 99% of my warnings but I'm still seeing this one which does not make any sense because input/output are defined as Nullable = No. When checking operator: When binding output schema variable "outRec": When binding output interfa...

Thanks for the info. Is there a way to set the NLS correctly at the job or stage level or do I need to change all the columns to NVARCHAR in the transformer? Assuming you are outputting to an NLS-compliant source and the map is set correctly for the target, then you should use NCHAR or NVARCHAR (the...

Hi Ray - I have the same problem... getting this implicit conversion error: When checking operator: When binding output schema variable "outRec": When binding output interface field "UPSTRM_SYS_CD" to field "UPSTRM_SYS_CD": Implicit conversion from source type "ust...

Yes it's easy to do, but the fact that your audit table is editable would violate your SOX requirements, at least for a vigilant auditor. Therefore the separate table is probably better. It would need to be keyed by KEY, INSTANCE and DTM. Make use of dynamic normalization to find the appropriate ro...

Is it possible to include comments in the "Reason for modification" in DS_AUDIT. I am trying to include which record number is associated with the jobs found in in DS_AUDIT for a external ticketing system. Used for our SOX audits. Current command being used SORT DS_AUDIT WITH DTC BY.DSND D...

I get the following below error I think when two jobs at the same time run the following SQL. The job is called lookup but it is really extracting a single row from Teradata. Item #: 51 Event ID: 26384 Timestamp: 2008-07-15 18:02:15 Type: Fatal User Name: etluser Message: ODBC_Tera_Prcs_Ctrl_Lookup,...

ray.wurlod wrote:It's not at the top of my priority list. The project I'm being paid to work on is nearing a deadline.

Understand completely. Thanks for the help.

Compiled date is one of the undocumented columns. It is not accessible as a column name. You need to work out which field contains it, and use an EVAL construct to access it. Actually, I just took a look at DS_JOBOBJECTS and can't find the compilation date. I may need to get back to you on that. Di...

If I read your e-mail correctly the compiled date is in ds_jobobjects but can not be printed. Or are you saying that I can do a select against ds_jobobjects and list the date.

Thanks for your response.

I have written a BAT script that takes a list of jobs and exports them one at a time into a a single dsx on your PC is this what you are looking for.

We are using Parallel jobs and I have been able to get a nice text report using DS_AUDIT. I am trying to find the compiled date that appears in the dsx exports. I am sure that this is probably in this forum but I am having a hard time finding it. I am just looking for a simple query that lists the j...

I am using ClearCase as my versioning tool. When I generate a .dsx I am getting some lines that are larger then 8,000 bytes. Is there a way to have the dsx files that are generated to have a single line less then 8,000 bytes. Or can I remove this limitiation for text file in ClearCase. Thanks Any he...

Thanks Ken, I added the RX to the command and it worked.

Will be looking at DsJobReport.bat - I have a script that will do an export and then generate the report based what was exported.

Thanks again