DSXchange

I have a question, why do you think you need to run a shell script especially from a Windows server? What is the purpose of this script?

Awesome job. Keep going until you understand all of these steps. You need to know a lot about BASIC to pull this off. You need to process multiple SELECT statements and not SQL type SELECTs. In BASIC a SELECT will create a list of IDs. An ID is the same as a key. You use this SELECT within a loop wi...

Do a search for DS.TOOLS.

There is a routine on my tips page which will validate the metadata. Download it.

Do a search for EtlStats.

That is my fault. That code needs to be removed but until then CREATE.FILE Sql2HtmlDriveP 19 I never think anyone is stupid especially if they are trying to do something new. You are learning. Give yourself some credit. I would not uncomment the code your are talking about. Leave it there. I would d...

I do prefer UNIX but that was not my point. Developing in one OS and implementing in another is bad even if it is 2 versions of UNIX. It is worse when it is Windows and UNIX. Just like Ray says the bug lists are different. Something may work fine in Windows and fail in production. You have made your...

You can use wc to get file size and number of rows. You easily write a routine to get these numbers. If you have fixed length records then it is a little more complicated. The post stuff would need to use EtlStats or write your own routines or jobs to get the number of rows processed from the job. D...

In BASIC when you



Then one of these files is created.

Silly Wabbit I gave you a 5. In fact I gave you two 5's. Does that make you a 10?

What he said and if that does not work then Save As a new job name. Next delete the old job. Rename the Save As version back to the original name. Then do eveything Ray said again.

There is no way I would do this. I would buy a small AIX box before I would develop on Windows and implement on UNIX. I would do LINUX before Windows. I think this is a very bad idea. I think the UNIX versions are all better than Windows anyway.

This is just my opinion. I hope it works for you.

Cobber is a good thang, right?

I wrote a routine which tries to resolve this issue. It is called KgdDebugMetadata. I hope you can find it. It was geared more to finding a bad column in line xxxx in the sequential file. I think you can modify it to meet your needs.

Welcome StageZilla. Nice name.