DSXchange

REQUIREMENT I am trying to have a common shell script that executes any BTEQ script (Teradata SQLs). Below is my generic shell script ---------------------------------------- SERV=$1 USER=$2 PASS=$3 DBN=$4 BTEQ_FILE=$5 bteq << EOF .logon $SERV/$USER,$PASS database $DBN; .SET ERRORLEVEL 3807 SEVERIT...

JOB: I read a SQL Server Table and then populate a text file(orderdetails.txt). Total record length of text file is 160 characters (total 15 columns). SEQUENCER: Once the job completes successfully, I am running a shell script (as below) that connects to a mainframe server and puts the text file ---...

My Mainframe guy gave a text file that had the COBOL FILE DEFINITION and few columns are like this 10 XF-PRIM-REG-ID PIC +9(02)V9(06). 10 XF-PRIM-REM-ID PIC +9(03)V9(06). It has a + sign in PIC 9 . Is this a correct CFD anyway, because I am not able to import this CFD from Manager. I know I can keep...

I am running a ftp script as below and it works fine. ftp -v -n abc.syscon.com user adminuser login1q2w3e lcd /company/user/shellscripts put flatfile.txt flatfile.txt put bye I am hardcoding the userid and password in FTP script. Anyway, to hide the userid/password in ftp script? Bascially I don't w...

When my job completes on Datastage Server, I need to connect to another UNIX server and put a empty file. I can call the unix script from a routine stage in sequencer: Below are the steps I need in the UNIX SCRIPT (1) Connect to a UNIX SERVER. (2) Go to a particular directory. (3) Create a .txt file...

I have a sequential file as a source that has over 150 columns. I have to read the file and dump the data to a teradata table. (1) Either I first create the table using CREATE TABLE command outside Datastage manually, then import the metadata and then use it as a target. OR (2) Is there any other wa...

I want to get a file from mainframe server(text mode or ascii mode) to the datastage server via a shell script using FTP.

Is there a sample FTP script available?

Thanks for your help.

I am reading a mainframe source file that has COMP fields. FTP Enterprise(get file as binary) > Transformer (nothing happening here)> Sequential File (export EBCDIC as ASCII) Data is converted properly, but I get a warning message. "Sequential_File_80: When checking operator: When validating ex...

I see lots of threads on CFF stage issue, COMP, Signed fields issues when reading file from mainframe file using FTP or Enterprise FTP plugin stage. Does any has a proper documentation either personal or from IBM, as to how the job should be designed in parallel to handle COMP and Signed Integers? I...

I am interested in becoming a premium member but was wondering if there is a possibility of reducing the membership amount $99.

Indeed this is a great site for all ETL developer and I myself have enjoyed the posts...yet in my humble opinion I think $99 is little more

Please post your COMPLETE FILE DEFINITION of the SOURCE. I recently came across COMP fields in Mainframe and have solved the issue using the server job.