DSXchange

Could any one please take this case ASAP?

Hi, I have a txt file which is tab delimited. And now if you have some extra tabs with in the data of a particular column then my sequential stage is giving an error saying "Trim_Test..Source.Extraction: read_delimited() - row 1, too many columns in record" For Example: If I have EMP_NAME ...

Hi I have used a command called "zip" and passed parameters as "TARGETDIR\FILEPATTERN" in an "ExecuteCommand" stage. Size has come from 24 kb to 4 kb.. but still files in that folder are not ".zip" extension. Could anyone please help me with this? Regards, Vin...

Hi all, I would like to archive files with minimal space while archiving. I have searched in the forums for a command for zipping a folder in datastage. Do anyone know a command used to zip a folder through "ExecuteCommand" stage? Could anyone please help me with this? Thanks in advance.. ...

There's no WriteSeq statement that would write anything to the flat file. If opened with OpenSeq, the statement to write a line is WriteSeq, not Write. If you want to use Write, open the parent di ... Thank you very much for all, with your support I was able to do that using a routine. Thank you on...

Hi all, I have tried using a routine to bring log entries and to write into a flat file. Following is the routine: **** Routine Name : GetJobLog **** **** Usage : Give the directory as the Input Value **** $INCLUDE DSINCLUDE JOBCONTROL.H ErrorCode = 0 Arg1=STAGE_DIR DirName = STAGE_DIR Suffix = &quo...

Welcome aboard. Yes, lots of us know. And a simple search of the forum would let you know also. ... hi Ray Thanks alot I have searched regarding log files in the forums and i got a simple and straight forward answer for my question that "The log records are in a database table within the Repos...

Hi, Any one know where the log entries of a job when it has been run in datastage will be stored? If we could able to find where these entries resided then, we can send mails if those entries contains warnings. If this works more clensing part can be skipped from the datastage jobs so that when ever...